Hello Lee,
This should work with just ENTER.
in AC2, then drag down.
=SUMPRODUCT((A$2:A$23=AB2)*(B$2:Z$23<>"")/COUNTIF(B$2:Z$23,B$2:Z$23&""))
Adjust the ranges. See the attached.
Regards,
Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread title
@googlegroups.com]
On Behalf Of CoRe
Sent: Apr/Fri/2012 12:58
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: formula required for count or count if
Hello Lee,
PFA!
If you have any queries ,give a shout ...
On Friday, April 27, 2012 7:30:32 AM UTC+3, lee wrote:
hi
i have data as
