Help with SUMIF function

  • Thread starter Thread starter Dino
  • Start date Start date
D

Dino

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
 
=sumif(Susan!c:c,"Yes",Susan!e:e) will add all the 'Yes' entries from Susan's
sheet. I think of the sumif if arguments as 1) where to look, 2) what to
look for and 3) what to add when you find it.
 
In your Totals sheet cell A1 - enter Yes
in cell A2 - enter No, then
in cell B1 of your Totals sheet enter
=SUMIF(Susan!$C$6:$C$10,Totals!A1,Susan!$E$6:$E$10)


Copy B1 to B2

HTH
 
It worked!!! Thanks bpeltzer and Jim!

Dino


Jim May said:
In your Totals sheet cell A1 - enter Yes
in cell A2 - enter No, then
in cell B1 of your Totals sheet enter
=SUMIF(Susan!$C$6:$C$10,Totals!A1,Susan!$E$6:$E$10)


Copy B1 to B2

HTH
Click to expand...
 
Back
Top