Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writeing a formula for
I need to write a formula for finding a % of a series of rows. However some
of the rows are not applicable. Examle of what I am trying to make happen: a | b | c | d 1 | 0 | 1 | 1 = 75% | 1 | | = 100% 0 | 1 | | = 50% The blank cells dont have a value so I dont want them to reflect in the result. I dont know how to write a formula to only use cells that have a value. What i have now is (a1:a4)/?? What do I divide it by. Please reply to |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writeing a formula for
=AVERAGE(IF(A1:D1<"",A1:D1))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) " wrote in message ... I need to write a formula for finding a % of a series of rows. However some of the rows are not applicable. Examle of what I am trying to make happen: a | b | c | d 1 | 0 | 1 | 1 = 75% | 1 | | = 100% 0 | 1 | | = 50% The blank cells dont have a value so I dont want them to reflect in the result. I dont know how to write a formula to only use cells that have a value. What i have now is (a1:a4)/?? What do I divide it by. Please reply to |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writeing a formula for
A non-array formula solution for the items in row 1 might be:
=COUNTIF(A1:D1,"0")/COUNT(A1:D1) (copy this to all rows with data; note that any rows with no data at all will generate a divide by zero error). " wrote: I need to write a formula for finding a % of a series of rows. However some of the rows are not applicable. Examle of what I am trying to make happen: a | b | c | d 1 | 0 | 1 | 1 = 75% | 1 | | = 100% 0 | 1 | | = 50% The blank cells dont have a value so I dont want them to reflect in the result. I dont know how to write a formula to only use cells that have a value. What i have now is (a1:a4)/?? What do I divide it by. Please reply to |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |