View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JenC JenC is offline
external usenet poster
 
Posts: 9
Default Simple Question - Sum If??

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