Get instant live expert help on I need help with excel chart ignore 0
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to set an average that IF a record is 0 to ignore that #
Solved by E. D. in 21 mins
=IF(O3:O347>0,IF(F3>G4,"YES","NO"),"NO") I want to express this as a percentage but want to ignore the original No count
Solved by X. H. in 30 mins
Need a chart to ignore cells that are empty (but have a formula within) and only pick up on the value in the cells once it differs zero.
Solved by B. F. in 12 mins
How to look up a single Criteria in multiple columns, but return only the results that do not result 0. Tried array formula: =VLOOKUP($B$2,Sheet2!$A:$T,{2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25},FALSE) but I need to ignore the 0 results being returned, but cant work out if Index function will do this for me...??
Solved by X. J. in 15 mins
I have the following formula using SUMPRODUCT, but I need it to ignore text and in cells. =SUMPRODUCT((MOD(ROW(D4:D19)+1,5)=0)*(D4:D19)) I know the formula works, because when I change the text to a number, I do not get the #VALUE! error. Can you help?
Solved by C. S. in 15 mins