HI, please support me in learning the use of Countifs/countif in Bonus calculation for below mentioned
HI, please support me in learning the use of Countifs/countif in Bonus calculation for below mentioned
So, in words, what is your criteria for Bonus? or exactly where are you looking for a formula?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You need to explain what/how you want to calculate. Show some expected results.
Sorry Guys, forgot to narrate, But have pledged it there. The condition is that any of the Seller has (must) sell all of his products to get bonus. If any of product is left in his basket he wont be eligible. i reckon it can be done with a consolidation of countif and countifs both nesting, but unable to do so.
So why does F3 (for example) = "No", because all products by Seller A must be sold for him/her to get the bonus?
If so, then in F3 copied down
=IF(COUNTIFS($C$3:$C$10,C3, $E$3:$E$10,"Un Sold")>0, "No", "Yes")
ChemistB, Seller A has 2 products ( J & K ) he has sold J but is K is left. so he doesnt qualify.
Condition for the Second Scenario is Sold and Invoiced Status will be qualified both as SOLD.
Okay, that's what I thought. My formula should work then (Post 5)
Thanks ChemistB, it worked for 1st case, kindly support in case 2 as well. thanks !
If you copy that down, it should work for all rows. Let me know what row it does not work for
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks