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!”
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