Highlighted Columns Count!

K

Killer

I have looked around but didn’t find anything towards what I trying to
achieve here...

I want to be able to highlight cretin columns and it will total up the
number of each column that has been highlighted.

Is this possible?
 
K

KC Rippstein hotmail com>

Not without using a macro.
However, if you could change your strategy and just mark the top of each
column with the letter Y (or whatever you want), then you could do a formula
like
=SUMPRODUCT((A1:Z1="Y")*(A2:Z100))
assuming your data is in columns A to Z and in rows 2 to 100.
- KC
 
Top