LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 64
Default SUMPRODUCT Problem

Column D = text values (client names) where the same name could appear more
than once in the column and where there could also be blank rows.

Column H = contains "Success" or "Failure".

I want to count the number of UNIQUE clients where I have had "Success" as
an outcome, as in the example below, where the answer would be 2:

Column D Column H
AlphaX Success
AlphaX Success
DeltaD Failure
CharlieW Sucess



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Problem with Sumproduct Maureen Excel Discussion (Misc queries) 4 March 31st 09 05:00 PM
SumProduct problem John Excel Worksheet Functions 5 February 23rd 09 01:52 AM
SumProduct problem robot New Users to Excel 4 August 12th 08 04:01 AM
Sumproduct problem. capt Excel Discussion (Misc queries) 7 January 13th 08 05:30 PM
SUMPRODUCT problem LeeHarris Excel Worksheet Functions 1 May 31st 06 10:23 AM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"