# Get instant live expert help on sumif in pivot 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 a table of checks with a date in column A and an amount in B. I want formulas to sum by year. =SUMIF(YEAR(A1:A10),2017,B1:B10) gives an error. If I add a column C with =YEAR(A1:A10) then =SUMIF(C1:C10),2017,B1:B10) works. Why? Better way short of a pivot table?
Solved by V. D. in 19 mins
I need help with sumif in google sheets formula / table
Solved by O. S. in 26 mins
Hi, i need a sumif formula for following table.
Solved by B. D. in 13 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