This yields 27
=SUMPRODUCT((RIGHT(B3:B17,1)=e)*(C3:H170))
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 the column
Dear All,
I need
I also like your solution :)
Thanks a lot working great.
Regards,
Pawel
From: dguillett1 dguille...@gmail.com
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