PDA

View Full Version : Reg; Excell cell count according to the cell values



rohanjayanth
03-03-2015, 10:58 PM
Hi all,

I have a very big table in that row and columns I have cell values "yes" and "no" es can I count HOW "yes" and "no" are available?

Please send me the macro to resolve the problem.

thanks in advance.

Bob Phillips
03-04-2015, 01:27 AM
No macro

=COUNTIF(table_range,"Yes")