Forum Discussion
Betsy Cleveland
Mar 20, 2019Copper Contributor
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.
ahmad ali
Mar 20, 2019Brass Contributor
Hi @Betsy Cleveland you can use =IF(Q7="*";SUM(X7:AA7))