Mar 20 2019 02:25 PM
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.
Mar 20 2019 03:07 PM
Mar 20 2019 04:10 PM
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.