Problem with nested IF's and something else.

Hi and welcome to the forum

Not sure what bonus you want to give, but this will determine if 1 is due or not, based on your rules...
=IF(A5=A4,"",IF(OR(SUMIF($A$5:$A$21,A5,$C$5:$C$21)>=355,COUNTIF($A$5:$A$21,A5)>=3),"Bonus",""))

(change the 355 for the "small"

You could try this (for the Big Stuff calculation):
In E5:

Formula:

Please Login or Register  to view this content.

Drag down to E23

(The little stuff):
In L5:

Formula:

Please Login or Register  to view this content.

drag down to L23

Hope this Helps

Edit-
just noticed, in your opening post, you are using ";" as delimeters so
E5:

Formula:

Please Login or Register  to view this content.

and
L5:

Formula:

Please Login or Register  to view this content.

I think I changed them all, but if you still get errors, I would check to make sure the ","'s have all been changed to ";"'s

There was one question I had about the requirements to the bonus though, if they sell 3 of a little item such as the op one at 69.99 then do you base your bonus calculation on the item price or the total price?

That is a good Question, My formulas are based on total sales...so would need some editing to work if its for individual items..

That was quite fast answer.
Requirements are based on TOTAL sales of the day. But bonuses goes on every item, if requirements met.
Thanks. I thought I'll have to wait at least a week for an answer. :D

Here is what I came up with. I've also added my notes and logic behind it so you could better understand how i came up with it and maybe learn a little something yourself.

I also adjusted the table to make your bonus program static in case any of the requirements or amounts change.

Quick peek at the formula's.

Big Items (Row 5)

Please Login or Register  to view this content.

Little Items (Row 5)

Please Login or Register  to view this content.

Hope this helps!

So, it is possible for the Bonus to equal 0 ( not likely, but possible, if all the utems sold fall under 250 (in the Big Stuff category) for example) ?
And would the quantity of the item sold affect this as well?

Okay this one does it for the individual sales, based of the daily totals :
(Note, I have changed your bonus table a bit, see attached)
in C5:

Formula:

Please Login or Register  to view this content.

drag down to C23

In L5:

Formula:

Please Login or Register  to view this content.

drag down to L23

(I haven't switched the comma's to semi-colon's here, but the workbook should do it when you download it)

Hope this helps

Dredwolf, I was playing around with yours to see if I could learn anything from it, and there seems to be some errors in it, (trying to pick apart right now to see what I can find and learn). When changing the quantity the bonus increases to a value based on the qty sold * price instead of a set value as determined by the table. Unless I'm misreading what he's stating and it is indeed based on qty of the item and not a flat rate.



I'm also trying to see why ou included the dates into the equation? Is there something I'm not seeing here on that one?

$A$5:$A$23=A5

@ vamosj
The reason for including the dates is that the bonus is based on daily sales numbers, as per opening post, I included a per item sold, as that was mentioned in OP's last post (#6), and I was not sure if they wanted it calculated on total sale of that item, or on a per item basis, so I basically guessed

Gotcha, thanks.