Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/0! How do I remove this answer?!?!?
I have multiple columns of data in another sheet and am using this formula
(entered as an array) to provide an average based on conditions, one column reads "2a", and another reads "38" etc. i thought that by by entering the IF formula to include "<0", this would count all the data and return a zero value for a blank or zero value. (I certainly hope this is making sense to somebody!!!) =AVERAGE(IF('Summary Days'!$D$3:$D$65536="2A",(IF('Summary Days'!$K$3:$K$65536=38,(IF('Summary Days'!$O$3:$O$1500<"0",'Summary Days'!$O$3:$O$1500)))))) This formula works if in all columns there is a value above zero, but returns "#DIV/0!" if not. This would be ok if my table wasn't presenting data for a fixed period.... Please help!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=D6-E6. Answer in F6. I want answer in F6 only if value in E6? | Charts and Charting in Excel | |||
Need An Answer To This! | Excel Discussion (Misc queries) | |||
not following your answer | Excel Discussion (Misc queries) | |||
please i need an answer | Excel Worksheet Functions | |||
i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) |