Get instant live expert help on sumif 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 sumif formula in excel 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
Hi, i need a sumif formula for following table.
Solved by B. D. in 13 mins
=IFERROR(VLOOKUPSTR(D26,'Pivot Table 2'!B:Q,16,'Pivot Table 2'!B:W,22,'Pivot Table 2'!B:AD,29,'Pivot Table 2'!B:AK,36,'Pivot Table 2'!B:AR,43,0),0)
Solved by I. F. in 30 mins
I am needing help modifying my Pivot table. I have a Pivot table but I cannot open the Pivot table options.
Solved by C. W. in 18 mins