Forum Discussion
Help with function COUNTIF
I am trying to count the cells in a column that contain a number value but only if another cell in the same row contains the specified text. (possibly using wrong function?) see below for example
I need to count all the cells contain a number value by lets say month of Dec
 
=+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,"<>")
16 Replies
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
Thank you all for the help! this works perfectly!
Go's to show I need to brush up on my excel skills 😉
That's what each of us do every day
=+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,"<>")
