looping through excel cells based on criteria using VBA

Dear Friend,



i am using excel2003.



my data:



status project



yes project1



yes Project2



yes project1



yes project2



yes project3



no project1



so i have the project name in the validation list.so if i choose project 1 from rhe validation list then i have to count how much "yes" and how mush "no" and have t odisplay the report in another worksheet.



so in next sheet my data disply should be as follows:



project name yes no

Project1 2 1

Project2 2 0

Project3 1 10



so can any one please give VBA code to do this please

if you just want the counts you just need to use a sumproduct function, there are many posts on this forum abouthow to use it

something like

Please Login or Register  to view this content.

Regards

Dav

Do you really need code?

A SUMPRODUCT formula will do the required calculations