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
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Killer" wrote:

I have looked around but didnt 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?