Forum Discussion
Help with function COUNTIF
=+COUNTIFS(E2:E7,E11,F2:F7,"<>")
please find attached screen shot
Month nov 1 dec 1 nov dec nov 2 dec 2 dec =+COUNTIFS(E2:E7,E11,F2:F7,"<>")
I am working on the last section of this excel sheet and I need a formula to figure the commissions earned.
It needs to add all the number values in a column then multiply that by the commission lets say $200 per entry.
I have found a way to do it but its a long and absurd method (needs to be cleaned up bad)
Don't Laugh but this is my poor attempt to try and solve this issue 😉
Each of the purple cells contains a value similar to this (=C8*200)
 
Sorry, but that's not clear, at least for me. Where is C8, is 200 fixed for all entries or variable, are column numbers variable or fixed, do you have total column in any case or that's just helper. In general = TotalInRow*200.
I apologies, I rushed that question started getting busy at the office.
Yes, the 200 is fixed for all entry's in that column but it needs to only count the values by the specified month like before
Sorry, but I don't see months at all on your screenshot. Could you please give bit more details, desirably with sample file, when you have time.
