Using SUMIFS to multply a cell

[SM mechanic]

I am trying to write a formula that will multiply the value in cell I15 by 5 if that cell is at 20 or more, and if cell I16 is equal to or higher than 105.95 and display the result in cell K15

In other words, I input 19 or less into cell I15, K15 shows 0

I input 20 into cell I15 and if cell I16 is 105.94 or less, K15 shows 0

If I input 20 into cell I15 and I input 105.95 or more into cell I16, K15 shows 100

Hope this makes sense.

It is for a commission based payroll, they need to sell 20 or more of this item at 105.95 dollars or more, and they get 5 dollars for each one they sell. If they don't sell at least 20 and if the average sale price is not at least 105.95, they don't get anything.

This is what I tried and its being rejected

=SUMIFS(I15*5,I15,">19",I16,">105.94")

Thank you for any help you can offer on this.

 

[Jonmo1]

Close, but put the *5 on the result of the sumifs, not I15 itself

=SUMIFS(I15,I15,">19",I16,">105.94")*5

 

[SM mechanic]

That returns 0 no matter what is input in to the other 2 cells

 

[Jonmo1]

Works for me.

Maybe I misunderstood what you're trying to do.
This will do I15*5 only if I15 is > 19 AND I16 is > 105.94

Book1
	I
15	25
16	108
17
18	125
Sheet1

Cell Formulas
Range	Formula
I18	=SUMIFS(I15,I15,">19",I16,">105.94")*5

 

[SM mechanic]

I was trying to post a screen shot to show you what I have but that's not working very well. What you are showing is exactly what I want it to do, other than I want ( in this example) 125 to show up in cell K15. But I assume if I cut and paste your formula in the formula bar when I am clicked onto cell K15, that's what should be happening. But it just shows $0

 

[SM mechanic]

Sorry, I figured out the problem, one of the cells had a number stored as text fault. reformatted the cell to be a number rather than a cell, and now it works.

thank you very much for the assistance.

 

[Jonmo1]

Then the one (or both) of the 2 cells are not meeting the criteria.
Best guess is that they are Numbers Stored As Text

What do these return
=ISNUMBER(I15)
=ISNUMBER(I16)

 

[Jonmo1]

SUMIF really isn't even appropriate for this task (unless you've posted simplified examples of something more complicated)

This should be sufficient, and will handle the "numbers store as text" issue

=IF(AND(I15>19,I16>105.94),I15*5,0)