Re: $$Excel-Macros$$ counting E in the column

2012-06-03 Thread dguillett1
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

Re: $$Excel-Macros$$ counting E in the column

2012-06-03 Thread pawel lupinski
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