SUM only Cells where there is text in Another cell
 

I am keeping stats for a football team. There are 2 columns A and B one for
each team. In these columns we enter text of what play was run. In Column C
we enter a number for either a loss or a gain on the play. I need to SUM
cells in column C, but want to seperate them by each team based if there is
text in the cell or not.

Example of the work sheet

A B C
Sweep Left 5
Run Right 3

I tried SUM(C3IF(A1,ISTEXT)) but I am not sure what to include if there is
no text? Using Excel 2007
Thanks

SUM only Cells where there is text in Another cell
 

Hi,

Try this. C3:C4 has the text values. E3:E4 has the score. The formula
below will yield 5 as the answer.

=SUMIF(C3:C4,"<",E3:E4)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MCook" wrote in message
...
I am keeping stats for a football team. There are 2 columns A and B one
for
each team. In these columns we enter text of what play was run. In Column
C
we enter a number for either a loss or a gain on the play. I need to SUM
cells in column C, but want to seperate them by each team based if there
is
text in the cell or not.

Example of the work sheet

A B C
Sweep Left 5
Run Right 3

I tried SUM(C3IF(A1,ISTEXT)) but I am not sure what to include if there is
no text? Using Excel 2007
Thanks