I have a document with 2 worksheets. I need to count how many times item
12W45 occurs and how many times this item has a value of <=3 in another
column. Here is the formula that I am using, or trying to use:

=COUNT(IF((Detail!H4:H32606="12W45")*(Detail!L4:L3 2606<=3),L4:L32606))

Something is wrong because it is giving me a value of 1, when it should be
7.
Can anyone tell what I am doing wrong?

hit F2 to edit your formula, then hit Cntrl+Shift+Enter.

if that fails try

=SUMPRODUCT((detail!H4:H32606="12W45")*(detail!L4: L32606<=3))
and just hit enter after keying it in.


"Lucien" wrote:

I have a document with 2 worksheets. I need to count how many times item
12W45 occurs and how many times this item has a value of <=3 in another
column. Here is the formula that I am using, or trying to use:

=COUNT(IF((Detail!H4:H32606="12W45")*(Detail!L4:L3 2606<=3),L4:L32606))

Something is wrong because it is giving me a value of 1, when it should be
7.
Can anyone tell what I am doing wrong?

Well, the SUMPRODUCT formula worked perfect.

Thanks for the quick answer!



"JMB" wrote:

hit F2 to edit your formula, then hit Cntrl+Shift+Enter.

if that fails try

=SUMPRODUCT((detail!H4:H32606="12W45")*(detail!L4: L32606<=3))
and just hit enter after keying it in.


"Lucien" wrote:

I have a document with 2 worksheets. I need to count how many times item
12W45 occurs and how many times this item has a value of <=3 in another
column. Here is the formula that I am using, or trying to use:

=COUNT(IF((Detail!H4:H32606="12W45")*(Detail!L4:L3 2606<=3),L4:L32606))

Something is wrong because it is giving me a value of 1, when it should be
7.
Can anyone tell what I am doing wrong?