Sumproduct question
 

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

Sumproduct question
 

Try this...

=SUMPRODUCT(--(B12:B100=G1),--(B12:B100<=G2),--(H12:H100="Logged"))
--
HTH...

Jim Thomlinson


"John in Wembley" wrote:


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

Sumproduct question
 

Hi John,

try it like this:

=SUMPRODUCT(--(B12:B100=G1),--(B12:B100<=G2),--(H12:H100="Logged"))

Personally, I prefer it like this:

=SUMPRODUCT((B12:B100=G1)*(B12:B100<=G2)*(H12:H10 0="Logged"))

Hope this helps.

Pete

On Feb 12, 5:13*pm, John in Wembley wrote:
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

Sumproduct question
 

Or this...

=SUMPRODUCT((B12:B100=G1)*(B12:B100<=G2)*(H12:H10 0="Logged"))


"Jim Thomlinson" wrote:

Try this...

=SUMPRODUCT(--(B12:B100=G1),--(B12:B100<=G2),--(H12:H100="Logged"))
--
HTH...

Jim Thomlinson


"John in Wembley" wrote:


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

Sumproduct question
 

Hi John

You need to coerce the True/False result for each of those tests to 1's and
0's
Either use
=SUMPRODUCT(--(B12:B100=G1),--(B12:B100<=G2),--(H12:H100="Logged"))
or
=SUMPRODUCT((B12:B100=G1)*(B12:B100<=G2)*(H12:H10 0="Logged"))

--
Regards
Roger Govier

"John in Wembley" wrote in message
...

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