Home

SUMIF formula help neded

Highlighted
Betsy Cleveland
New Contributor

I am using a SUMIF formula (=SUMIF($Q7,"*",X7:AA7)) which will only work when X7 has a value.  If it is 0 it will not work.  Any suggestions.

2 Replies
Highlighted
Hi @Betsy Cleveland you can use =IF(Q7="*";SUM(X7:AA7))
Highlighted

@Betsy Cleveland 

The formula, is working; it only ever considers column X.

To sum over the range X7:AA7 the criteria range needs to be the same 'shape', i.e. a row of 4 cells, $Q7:$T7.