View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dino
 
Posts: n/a
Default Help with SUMIF function

Would someone please help me think this through....

I have a workbook with a sheet named Susan and a sheet named Totals. On the
Susan sheet, column C is a yes or no answer (using data validation). Column
E is for dollar amounts. OK...on the Totals worksheet, I need a line that
says Yes Totals (which totals all the Yes's in column C of sheet Susan) and
one under that that says No Totals (which totals all the No's in column C of
sheet Susan)

Example on the Susan sheet
C6=Yes E6= $100
C7=Yes E7= $50
C8=No E8= $10
C9=Yes E9= $15
C10=No E10=100

On the totals sheet I want it to read:
Yes $165
No $110

I'm sure I can do it with a SUMIF, but I'm getting myself totally confused
at this point.

TIA
Dino