Get instant live Excel expert help with SUMIF functions

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

i need to combined both my sumif formula and vlookup formula that i have in the file but separate

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?

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

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

I am using SUMIF nested formula, and I need a way to dynamically reference a column on another sheet using a cell

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)

I need help doing a VLOOKUP and SUMIF for two different excel worksheets that include different questions.

Greetings, I need help creating a sumIf and countif formula. Also need help interpreting the sheet. Will provide more information. Thanks!

I need a SUMIF formula that can add totals of invoices due by week by department