Get instant live Excel expert help with SUM Function

I am trying to build an equation that supports two variables to create a sum. The specific calculations I am trying to create are highlighted in yellow from 18-32. You will see the text in red with the results I am trying to achieve. Please help and Thank you!

I WANT TO MATCH MULTIPLE QUANTITIES TO SUM TO ONE TOTAL BUT I WANT TO FORMULA TO SHOW ME THE QUANTITIES USED TO GET TO TOTAL

I have 10 worksheets that have identical row names and content. The columns are all dates. But each worksheet has a different date in column B. I want to consolidate those 10 worksheets into a consolidation tab such that the values in the columns will sum in the consolidated sheet based on matching up the specific date. The columns are headed with date values. I am trying to use the sumif function based on the criteria that the dates in the worksheets exactly match the date in the consolidated worksheet. Help

D is the amount of units available for the PC (A), E is the amount of units requested by account (B). Looking for a formula in column I. It needs to look at the difference between E and G and fill in those units based on the quantity in G20 (the amount of units available to use) Note G20 is not a sum of G1-G19.

Hi, can you help with these formulas. Source data comes from Style Status Report TAB to summarise into categories using column A - Open to Buy Tab and column D - Style Status Report TAB. All formulas will need to include this. Formula 1. COLUMN K8 - can you fix this formula for me? FORMULA for K8 = sum of column M - W/H Qty but only add if column E is not equal to 11ONL and column N is equal to "blank" or under 4 and if column O is equal to 00-00-0000. The result in K8 should = 385 FORMULA 2 - Column L This is the same as above - but I need to "count as 1" the Name keys in Column C - that return the value of the formula above in column K. The result in Column N8 = 3 thanks

Hello, creating a sheet for reception for google sheets. Date, brand, name, tel, type of enquiry, month Summary sheet brand, sum of date entered above, sum of month of above How can I do this, have sheet with data so far

What formula to use: entries by row are rated 1 to 5 for importance in column B I would like to calculate the sum of all cost values in column C, which meet the specific importance criteria e.g The sum cost of all entries with importance 1

I need a formula in cell I6 that says- IF C6 > 26 then sum Cells I3:15 if not then give me zero I thought this would work but it's not =SUMIF(C6,">26",I3:15)

So here is my issue. I'm using excel to calculate out the debt service that I need to support a hypothetical development, and the sumif function doesn't seem to want to work given the formulas I've setup. So the debt service is a basic amortization table debt service table over 25 years. But for the development I only need to be worried about the debt service on the loan through the period that I'm doing the development. In this case 8 months of the 25 year time frame. To get the schedule I setup a schedule that returns period dates based on the month and year. I think referenced that date using the following function: =INDEX('Project Schedule'!$1:$1,MATCH(G4,'Project Schedule'!$2:$2))+1 This references the months in Row 2, and returns the Period Value in Row 1. In this case returning the value of 14. but when I use a basic SumIf function to sum the total cost of the payments into the loan, it returns a "zero" value. Here is my sumif function SUMIF(A10:A410,"<=F4",G10:G410) Now if I just replace F4 with the value 14 it works and calculates correctly, but if I reference the cell F4 it returns a zero value. My only thought is that the Index function screws this up, and doesn't actually return a number value. Your thoughts?

If the sum of D7 is 585 then the sum of E7 should be 599. If any last two digits from the sum of E7 is greater than 29, then the sume of E7 should be X49. Also, how to lock the cells which has formula applied on it.