Posted to microsoft.public.excel.worksheet.functions

Joe Gieder Joe Gieder is offline

external usenet poster

Posts: 73

Count Unique Values

I'm trying to count unique values based on muliple criteria. I tried using
the formula
=SUMPRODUCT(--(B2:B2500=B2),--(D2:D2500="HY")/COUNTIF(F2:F2500,F2:F2500)) but
when there's a blank in column "F" I get an error. Can this formula be writen
to ignore blank cells?

Thank you in advance for your help
Joe

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count of unique values	Matt	Excel Discussion (Misc queries)	8	January 20th 09 07:34 AM
Count Unique Values	Dave	Excel Worksheet Functions	5	December 4th 08 10:20 PM
count unique values, if ...	Averitt Engineer[_2_]	Excel Worksheet Functions	2	February 15th 07 06:41 PM
Count unique values and create list based on these values	vipa2000	Excel Worksheet Functions	7	August 5th 05 01:17 AM
Count Unique Values	annie	Excel Worksheet Functions	1	June 9th 05 07:19 AM

All times are GMT +1. The time now is 02:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us