Need Small Macro for Counting Total Approved No.s in Given Table

[structo]

Dear All,

I need small macro for count the total No. of "Approved" with respect to their names. macro should produce the result at "O" column by numerical numbers.

please suggest any one.

Thanks in Advance.

[Roel Jongman]

Is a formula also acceptable.. it is very easy to solve with sumproduct() for older excel versions

change the contents of N column with only the names and then use this formula

Please Login or Register  to view this content.

also see attachment

[MickG]

Another option !!

Please Login or Register  to view this content.

Regards Mick

[maras_mak]

Try.

[structo]

Hi Roel, Thank you formula working but some cases my file with merged cells as attached example sheet. can you please share the formula for this situation?

[maras_mak]

Try.

[structo]

Try.

Thank you, can you please formula version for this merged cell condition.

[structo]

Is a formula also acceptable.. it is very easy to solve with sumproduct() for older excel versions

change the contents of N column with only the names and then use this formula

Please Login or Register  to view this content.

also see attachment

Thank you so much your formula version. it is simple and effective. can you please modify for merged cell condition. i have attached sample sheet,

[maras_mak]

I need small macro for count ...

My code works very well even on merged cells.

[structo]

My code works very well even on merged cells.

Yes but i need formula version too for merged cell, please share.

[Roel Jongman]

When you have merged cells then you need to make sure that the first column of the merged cells is mentioned in the formula

so in this case G instead of H

Please Login or Register  to view this content.

[structo]

When you have merged cells then you need to make sure that the first column of the merged cells is mentioned in the formula

so in this case G instead of H

Please Login or Register  to view this content.

Thank you for modification, i have tried but got different results comparing with actual results. please have a look and guide me.

[Roel Jongman]

Behind the names James and Steve there is a still a space. if you remove the space then they will match. So you need to be accurate with the spelling of the names incl spaces you cant see.