how can i use countif function inside a filtered range

[jayin]

How can I use countif function inside a filtered range

 

[Shane Devenshire]

Hi,

Not much detail here, so this is the general idea:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(C13:C18,ROW(13:18)-13,0,1)),--(C13:C18="Red"))

 

[pauladkin]

Shane Devenshire wrote on 02/24/2009 02:05 ET

Hi

Not much detail here, so this is the general idea

=SUMPRODUCT(SUBTOTAL(3,OFFSET(C13:C18,ROW(13:18)-13,0,1)),--(C13:C18="Red&quot

If this helps, please click the Yes butto

Cheers
Shane Devenshir


"jayin" wrote

H
can you advise how I would extend the command to include a further conditio
such a
--(a13:a18=n2)

I am trying to get the summary boxes to count visible rows only and where th
project is closed and its budget is over the value in a cell i.e n

I have tried just adding it to the end but clearly that would be too easy !

Thank
Paul.

 

[Roger Govier]

Hi

Try
=SUMPRODUCT(SUBTOTAL(3,OFFSET(C13:C18,ROW(13:18)-13,0,1)),
--(C13:C18="Red"),--(A13:A18=N2))


--

Regards
Roger Govier

Shane Devenshire wrote on 02/24/2009 02:05 ET :
Hi
can you advise how I would extend the command to include a further
condition
such as
--(a13:a18=n2))

I am trying to get the summary boxes to count visible rows only and where
the
project is closed and its budget is over the value in a cell i.e n2

I have tried just adding it to the end but clearly that would be too easy
!!

Thanks
Paul.

__________ Information from ESET Smart Security, version of virus
signature database 5206 (20100618) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5206 (20100618) __________

The message was checked by ESET Smart Security.

http://www.eset.com