Simple Question - Sum If??

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
 
J

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
 
J

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple IF Statement in Word 5
Get percentage of whole 2
Multiple Columns in Sum Range using SUMIFS 1
Adding a big matrix in Word 2013 5
Multiple logic functions with multiple sums 2
Using SUM(INDIRECT()) 2
Sum data using sumif 3
Sumif apllying to all sheets in workbook 2

Top