Simple Question - Sum If??

  • Thread starter Thread starter JenC
  • Start date Start date
J

JenC

I'm trying to do something simple but I'm getting confused between the
different SUM functions and can't figure out which one I should be
using...advice much appreciated!

I have one column with integers and a second column with "Y" or "N". I can
sum the integers no problem. However, I also want to sum all the values for
which the other column says "Y". What function should I use?

Thanks,
Jen
 
ColB with Y or N and Col A with numerics..Try the below to return sum for Y

=SUMIF(B:B,"Y",A:A)

If this post helps click Yes
 
Thanks so much to both of you - I knew it was simple but kept getting
confused by all the sum functions available!

Jen
 
Try this...

A1:A10 = Y or N
B1:B10 = values to sum

=SUMIF(A1:A10,"Y",B1:B10)

Or, using a cell to hold the criteria...

D1 = Y

=SUMIF(A1:A10,D1,B1:B10)
 
Back
Top