| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Highlighted Rows | Excel Discussion (Misc queries) | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| How to Count Substrings InTwo Columns | Excel Worksheet Functions | |||
| If two columns match then count one. How? Tried countif and sum . | Excel Worksheet Functions | |||
| count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions | |||
Linear Mode
