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?