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 to add =SUMIF(Info!C4:D4,"=8","/2") into an existing formula. =SUM(Info!D4-Info!C4,(SUMIF(Info!C4:D4,"=1")/2*8)). when I try to add it in it brings up errors
Solved by K. U. in 25 mins
i need to combined both my sumif formula and vlookup formula that i have in the file but separate
Solved by D. S. in 13 mins
Hi, I'm making myself a weekly budget spreadsheet. I've made a sheet with all my monthly outgoings, and I've worked out how to use SUMIF to combine the amounts for each day, but I want to include a reference and don't know how to combine text cells based on a specific date reference... does that make sense?
Solved by E. U. in 23 mins
I need the SUMIF formula, to do this: 1) If the letter in column A2:A5 is "A"... 2) The numbers in column B2:B5 will be added to the total, provided that... 3) The numbers in column B2:B5 match their corresponding number in column C2:C5
Solved by T. E. in 25 mins
I need a formula that combines two separate revenue calcs together: (1) SUMIF based assignment of revenue based on calendar month/year; (2) SUMPRODUCT with SUBTOTAL that sums revenue by category
Solved by X. C. in 19 mins
I am using SUMIF nested formula, and I need a way to dynamically reference a column on another sheet using a cell
Solved by Z. Y. in 25 mins
I need this sumif statement for every month of the year. The only thing that changes are the months (each corresponding to a different sheet) Is there a shorter way to combine these? something like July:June that will work? sumif(July!G10:AE10,$AK$7,July!G9:AE9)+sumif(August!G10:AE10,$AK$7,August!G9:AE9)
Solved by B. F. in 15 mins
I need help doing a VLOOKUP and SUMIF for two different excel worksheets that include different questions.
Solved by O. J. in 30 mins
Greetings, I need help creating a sumIf and countif formula. Also need help interpreting the sheet. Will provide more information. Thanks!
Solved by F. H. in 12 mins
I need a SUMIF formula that can add totals of invoices due by week by department
Solved by S. Q. in 27 mins