I have this function in Excel 2007:
=SUM(IF(B1:B6="no",0,1/COUNTIFS(A1:A6,A1:A6,B1:B6,"yes")))
*array formula*
Here is what is located in A1:B6..
2002 yes
NH10 no
NH10 yes
NH10 yes
FR54 yes
FR54 no
Basically I need a unique count of all items in column A where the value in colun B is equal to yes. Thanks!
COUNTIFS, as you are aware, is specific to Excel 2007. Can you think of a way to redesign this formula so that it works in Excel 2003? I have tried a variety of SUMPRODUCT formulas but I haven't been able to reproduce the answer I need.
Bookmarks