Highlighted Columns Count!
 

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?

Highlighted Columns Count!
 

Ok thanks so it's not possible...

"KC Rippstein" wrote:

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?

Highlighted Columns Count!
 

The best I can offer is that if you are using your mouse to select the data,
then Excel does show you an auto sum of the highlighted data down in the
lower right corner of the screen.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Killer" wrote:

Ok thanks so it's not possible...

"KC Rippstein" wrote:

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?