Get instant live Excel expert help with SUMIF functions

“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

I need help with excel sumif greater than and from a different sheet.
Solved by D. J. in 14 mins
I am trying to do a SUMIF calculation and when I hit insert function and then chose SUMIF it brings up 3 things: range, criteria and sum_range. I can properly select the data I want in there (ex: E2:E6) but I want to make it and absolute cell reference and I am using a mac so I highlight it and click command t but a "ding" noise pops up and it doesn't allow me to change it. I am not sure why. I am following along with an excel module program and the instructor does it frequently and it works every time for him. I have attached a file, and the first sheet is empty and the second sheet has the formula I am supposed to put in.
Solved by I. J. in 27 mins
I need a formula like sumif but works with text.
Solved by E. J. in 24 mins
Sumif, scanning column B for values less than the value in the same row in column C. I can only make it work if I actually enter the value in col C into the fomula in col B separately on each line. Surely I can refer to the value in Col C then copy the formula down.
Solved by D. B. in 30 mins
I'm trying to use SUMIF to collect data from all months in a specific year into one total. It keeps coming up as a zero. =SUMIF('Monthly Summary'!F6:AU6,"18*",'Monthly Summary'!F10:AT10) Is the formula I have entered where row 6 is the date (1801, 1802, format, etc,) and row 10 is the revenue I want to add together.
Solved by B. J. in 12 mins
Is it possible to sum up numbers based on font color? I would appreciate some kind of sumif formula for that
Solved by F. D. in 22 mins
I can not get the sumif function in excel to work with numbers
Solved by O. E. in 27 mins
I can not get the sumif function to work. My trial function is in cell k10
Solved by F. F. in 18 mins
I need to use the SUMIF function to compute the sum of cells E6:E21 if the cell in the range D6:D21 is equal to cell K8
Solved by O. U. in 13 mins
Every time I add the quotes to this formula it stops working? SUMIF(C7:BB7,"<=BC6",C10:BB10). I am trying to add some numbers based on a date range.
Solved by C. E. in 17 mins