 # 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