Hello,
I have a formula to find the average like this: SUM(A1:A5)/COUNTIF(A1:A5,">"&0)
The formula above is applied for range. Now I want to apply by individual cells how can I use the countif like above. For example, I want to find an average in column S2 and W2 if S2 is 0 then I just need to use W2 number. If I applied formula above, it would look like this SUM(S2,W2)/COUNTIF(?). Since Countif only allows to use range, how can modify this formula and get what I expected. Please help.
Thanks,
Bookmarks