count similar text with using filters

's Computer Specifications

I want to count the number of occourances of a "Y" in coulumn D .. so i used
a countif and it works great however when i filter another column it still
counts all the "Y".

's Computer Specifications

Hi,
try

=SUMPRODUCT(SUBTOTAL(3,OFFSET(d2:d11,ROW(d2:d11)-MIN(ROW(d2:d11)),,1)),
--(d2:d11="Y"))

change range to fit your needs
"mj" wrote:

> I want to count the number of occourances of a "Y" in coulumn D .. so i used
> a countif and it works great however when i filter another column it still
> counts all the "Y".

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Question - Similar Data	Kimmie	Microsoft Excel Worksheet Functions	1	12th Dec 2008 09:29 PM
count with data filters on	PeterM	Microsoft Excel Discussion	7	17th Sep 2008 02:33 AM
How can you use count with an array formula similar to using sum	=?Utf-8?B?UGhpbEg=?=	Microsoft Excel Worksheet Functions	3	27th Jun 2005 08:00 AM
How can I count similar word in raw?	=?Utf-8?B?UGluYWtlZW4gUGF0ZWw=?=	Microsoft Excel Misc	1	9th Mar 2005 08:28 PM
count mumber of similar itmes	Richard	Microsoft Access	2	11th Nov 2004 03:06 AM