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