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,"<>")
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.
Here is a sample of the doc I'm working on.
On the tracker page I am trying to calculate the $200 commissions earned for each home on the data page by month.
Thank you, but file doesn't explain the logic for me. Why for Jan you calculate sum of working hours * 200, but for Nov Changes*2? I'm not in your business and have no idea what's that about, if you explain more close to Excel terms that will be great.