Simple Question - Sum If??

[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

 

[Mike H]

Hi,

=SUMIF(A1:A20,"Y",B1:B20)

Mike

 

[Jacob Skaria]

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

 

[JenC]

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

Jen

 

[T. Valko]

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)

 

[Glenn]

http://www.contextures.com/xlFunctions01.html

Might help clear up some of your confusion...