Home

SUMIF formula help neded

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
Hi @Betsy Cleveland you can use =IF(Q7="*";SUM(X7:AA7))

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies