SUM only Cells where there is text in Another cell

[MCook]

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

 

[Ashish Mathur]

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