This yields 27
=SUMPRODUCT((RIGHT(B3:B17,1)="e")*(C3:H17>0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Sunday, June 03, 2012 1:41 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ counting "E" in t
I also like your solution :)
Thanks a lot working great.
Regards,
Pawel
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Sunday, June 3, 2012 7:56 PM
Subject: Re: $$Excel-Macros$$ counting "E" in the column
This yields 27
=SUMPRODUCT