Home |
Search |
Today's Posts |
#1
|
|||
|
|||
question for excel how to have linked sum in column?
Hi, I have a column that is full of Y's and N's as values. I am constantly
adding to this column so for example- on day one I might have 50 Y's and 50 N's in this column and day 2 i might have 100 Y's and 50 N's in this same column. How do I make a chart/table in excel that will automatically give me the current # of Y's and N's in this column as well as their respective percentages? So if I checked on day 1, this chart will tell me I have 50 Y's and 50 N's (in column C for example) and that 50% of the values are Y and 50% are N. On day two the chart will tell me I have 100 Y's and 50 N's and that 66.67% are Y and 33.33% are N. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about deleting rows from sorted linked worksheets | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
lookup in colum a and compare values in colum b | Excel Worksheet Functions |