Sumif, Sumproduct Question.

  • Thread starter Thread starter Jesse
  • Start date Start date
J

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
 
Jesse said:
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
Click to expand...

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))
 
Hi Jesse
try this
=SUMPRODUCT((A2:A161="conversion")*(C2:C161="Prep")*(B2:b161))

HTH
Frank
 
Back
Top