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

Hi,

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

Mike

"JenC" wrote:

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
---------------
Jacob Skaria


"JenC" wrote:

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

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

Jen

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"JenC" wrote:

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

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

Might help clear up some of your confusion...


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

Jen

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"JenC" wrote:

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

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)

--
Biff
Microsoft Excel MVP


"JenC" wrote in message
...
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