# 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