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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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