Can someone please tell my why my formula works like:
=COUNTIFS('Job Entry Form'!A:A,G6,'Job Entry Form'!K:K,">="&I6,'Job Entry Form'!K:K,"<="&J6,K:K,">=4",K:K,"<=7",'Job Entry Form'!J:J,"Yes")
but not like:
=COUNTIFS('Job Entry Form'!A:A,G6,'Job Entry Form'!K:K,">="&I6,'Job Entry Form'!K:K,"<="&J6,K6,">=4",K6,"<=7",'Job Entry Form'!J:J,"Yes")
I am trying to get it to check a particular cell (K6) instead of the whole (K:K) column. I know this has to be possible, any help on what I'm doing wrong?
It's on the "Running Log" page. I am trying to help my wife build a tool to help her keep track of her salesman's commissions and bonuses. It works for pulling the info she needs on a weekly basis, but I want to make a running total page for he as well, so I can make a reconcile page.
Thanks in advance,
David
Bookmarks