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. |
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. |
All times are GMT +1. The time now is 05:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com