Get instant live Excel expert help with SUMIF functions

I am working on a cash flow projection. Part of the projection includes sales commissions. Our sales guys earn a monthly draw and then commission on sales after a certain amount. For example they may earn a monthly salary of 12,500 and earn additional commission after their commission equals $150,000. What I need excel to do is sum a column if the values in the preceeding columns are greater than $150,000. I've tried using the sumif and the if function in excel and it's not working correctly either way. Any suggestions?

I am trying to figure out how to use a sumif on SUBSTITUTE(A2,"*","~*") where A2 is a formula with 3371-4

So im trying to use a sumif formula, but i need it to not look for a range for one specific criteria but instead look for what one specific field says. Example Below =sum(sumifs(QuantityMC,TeamsMC,A6,TypeMC,B2)) The above formula works as on the specific MC sheet an entire column is dedicated for "TypeMC". I want to be able to delete this column and have "TypeMC" to be a single field as it will be the same for every item on that sheet but may differ on a different sheet.

Hi! I'm having trouble with a SUMIF referencing a different sheet within the workbook. =Sumif(Ledger!A2:A1000, "1001-01", [Ledger!E2:E1000]) Ledger is the name of the other sheet I'm trying to reference.

excel formulas not working, formula is correct but due to list its not working

Hi! I have trouble with a SUMIF function because I'm trying to reference 2 different worksheets

In cell M1, use the SUMIF function to total the number of students (Size) enrolled in the State of Kansas. In

Sumif help to display text once the cell is over a certain value

I would like to use the SUMIF formula in multiple Sheets in Google Sheets, is this possible ?

17. On the Summary worksheet, create formulas to complete the summary table in C5:G8. You must use conditional aggregate functions (COUNTIF, COUNTIFS, SUMIF, AVERAGEIF).