# Get instant live expert help on sumif excel table

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

how to use excel sumif multiple criteria and whats the difference between Pivot table sumif?
Solved by E. J. in 12 mins
I have built a table in SQL that takes into account parameters defined by the user in Excel cells (in the SELECTION sheet). I have completed this table, defined in TABLE_SOURCE_1 sheet, with columns having Excel formula. The problem is that in TOTAL_TAT column I have entered : =SUMIF(B2:B7,[@[CONTACT_NUMBER]],K2:K7). For certain parameters, the table is empty and the formula becomes : =SUMIF(B2:B2,[@[CONTACT_NUMBER]],K2:K2). This is a problem because when I modify the parameters so that the table contains values, this formula remains : =SUMIF(B2:B2,[@[CONTACT_NUMBER]],K2:K2) and not what I want : =SUMIF(B2:B7,[@[CONTACT_NUMBER]],K2:K7).
Solved by K. H. in 20 mins
Hi, i need a sumif formula for following table.
Solved by B. D. in 13 mins
I need help with sumif in google sheets formula / table
Solved by O. S. in 26 mins
To group and total values in excel: Formula not allowed.=SUMIF(A2:A10,"A2", B2:B10). Excel rejects with message: problem with the formula Tried to include " in front of = as per excel advise. " =SUMIF(A2:A10,"A2", B2:B10) Also tried: =SUMIF(\$A\$2:\$A\$10,"A2", B2:B10)
Solved by T. H. in 27 mins