Help with SUMIF function

[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

 

[Guest]

=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.

 

[Jim May]

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

 

[Dino]

It worked!!! Thanks bpeltzer and Jim!

Dino

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