J
John in Wembley
Hi all mighty sumproduct experts.
What ovious thing do I have wrong?
G1 is the start date
G2 the end date
I wish to count all the jobs "Logged" between these dates
Col B holds the date the job was logged.
=SUMPRODUCT((B12:B100>=G1),(B12:B100<=G2),H12:H100="Logged")
currently does not work
thanks
john
What ovious thing do I have wrong?
G1 is the start date
G2 the end date
I wish to count all the jobs "Logged" between these dates
Col B holds the date the job was logged.
=SUMPRODUCT((B12:B100>=G1),(B12:B100<=G2),H12:H100="Logged")
currently does not work
thanks
john