Count only cells within Filtered Range

[Corey]

I'm using the 'Countif' function. But I want to limit my range to the cells
in a filtered range. Is this possible?

For example I want in my range, i.e. C13, C15, C18 instead of C13:C18?

 

[Gary''s Student]

See SUBTOTAL in Excel Help.

 

[Shane Devenshire]

Hi,

If I read the post correctly you want to COUNTIF(C1:C25,"Red") but only for
visable cells, is that correct?

If so, I don't think you can do it with SUBTOTAL

 

[Corey]

Do you know what I can do?

Hi,

If I read the post correctly you want to COUNTIF(C1:C25,"Red") but only for
visable cells, is that correct?

If so, I don't think you can do it with SUBTOTAL
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Glenn]

I'm using the 'Countif' function. But I want to limit my range to the cells
in a filtered range. Is this possible?

For example I want in my range, i.e. C13, C15, C18 instead of C13:C18?

See if this helps:

http://www.contextures.com/xlFunctions04.html#Filter

Otherwise, provide more details about your worksheet.

 

[T. Valko]

What is the condition that you want to count?

Assuming the full unfiltered range is C13:C18 and you want to do a
COUNTIF(C13:C18,"Red") when the range is filtered:

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