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. |
#2
|
|||
|
|||
Jon,
=COUNTIF(A2:A2000, "y") =COUNTIF(A2:A2000, "n") =COUNTIF(A:A, "n") They'll count Y and y, N and n. For %, you can use: = C1 / (C1 + C2) = C2 / (C1 + C2) where C1 and C2 contain the formulas above. Or you could use a stacked column chart. -- Earl Kiosterud "Jon Danziger" <Jon wrote in message ... 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. |
Reply |
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 |