Sumif, Sumproduct Question.

[Jesse]

This may be an easy question...

I have an error log spreadsheet that is used to log what
kind of error has been made and by what department of the
company the error was generated. For example... Columb A
holds what department the error was made in... Columb B
holds how many pages were wrong... and Columb C holds the
type of error (Prep, Imaging, Misc). The problem I've come
across is... I only need to calculate how many errors have
been made by each department when Columb A = Conversion
(or whatever the name of the department may be) and Columb
C = Prep.

I tried this formula but it didn't work.

=sumif(a2:a161,"conversion",b2:b161)-sumif
(c2:C161,"Prep",b2:b161)


I hope this is understandable. Please contact me if you
have any questions! Your help is greatly appreciated!
Thanks again.

Jesse Harris

 

[Paul]

This may be an easy question...

I have an error log spreadsheet that is used to log what
kind of error has been made and by what department of the
company the error was generated. For example... Columb A
holds what department the error was made in... Columb B
holds how many pages were wrong... and Columb C holds the
type of error (Prep, Imaging, Misc). The problem I've come
across is... I only need to calculate how many errors have
been made by each department when Columb A = Conversion
(or whatever the name of the department may be) and Columb
C = Prep.

I tried this formula but it didn't work.

=sumif(a2:a161,"conversion",b2:b161)-sumif
(c2:C161,"Prep",b2:b161)


I hope this is understandable. Please contact me if you
have any questions! Your help is greatly appreciated!
Thanks again.

Jesse Harris

To count the number of errors, try this:
=SUMPRODUCT((A2:A161="conversion")*(C2:C161="Prep"))

To sum the number of pages in those errors, use this:
=SUMPRODUCT((A2:A161="conversion")*(C2:C161="Prep")*(B2:B161))

 

[Aladin Akyurek]

=SUMPRODUCT(--($A$2:$A$161=Dept),--($C$2:$C$161=ErrType),$B$2:$B$161)

 

[Frank Kabel]

Hi Jesse
try this
=SUMPRODUCT((A2:A161="conversion")*(C2:C161="Prep")*(B2:b161))

HTH
Frank