LinkBack URL
About LinkBacks
Hi,
Please find the attachment and give the solution as asking in the attachment. Please solve the problem using formula only. No VBA.
Thanks in Adavnce.
Hi,
Please find the attachment and give the solution as asking in the attachment. Please solve the problem using formula only. No VBA.
Thanks in Adavnce.
This will give you what you need...
=AVERAGEIF(E3:E10,"<>N/A",E3:E10)
For future reference, please include your question IN your thread, not your file. That way, members dont need to openthe file to see if they want to take up your question
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thank you for you reply it is working
and thank you for your advice
Hi,
Can you pls tell me what is the wrong in the below formula.
IF(or(A3="0",if(or(A4="0",if(or(A5="0",if(or(A6="0",if(or(A7="0",if(or(A8="0",if(or(A9="0",if(or(A10="0"))))))))))))))),"0",A11/(B11-(SUMIF(A3:A10,"=N/A",$B$3:$B$10))))
Well to start with, if you are testing for 0 (the value 0), trhen you need to remove the "" from around them
Also, if you are only test1ing 1 criteria, you dont need OR()...
=IF(OR(A3=0,A4=0,A5=0,A6=0,A7=0,A8=0,A9=0,A10=0),0,A11/(B11-SUMIF(A3:A10,"=N/A",$B$3:$B$10)))
Or shortened to...
=IF(COUNTIF(A3:A10,0)>=0,0,A11/(B11-SUMIF(A3:A10,"=N/A",$B$3:$B$10)))
Thank you very much Fdibbins...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks