Forum Discussion
SUMIF formula help neded
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
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.
- Hi @Betsy Cleveland you can use =IF(Q7="*";SUM(X7:AA7))
