SUM only Cells where there is text in Another cell

M

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Sum of values in column A based on 0/1 of column B 2
Setting column width in a table with a macro is not working 0
Get sum of values in a cell based on unique values in another cell 3
Sum of Variable Cells in a fixed Row 3
use month in cell date to sum all relevant cells 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Lookup multiple cell values and place contents in a single cell 3

Top