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.
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.