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

Help with SUMIF function
 

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

"Dino" wrote:

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

Help with SUMIF function
 

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" wrote in message
...
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

Help with SUMIF function
 

It worked!!! Thanks bpeltzer and Jim!

Dino


"Jim May" wrote in message
news:KPWgf.44925$4n5.7174@dukeread01...
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" wrote in message
...
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