G
Guest
Thanks so much for the help yesterday, but I have run into another problem
that might just be syntax, but I can't seem to solve it. first, in a table I
have a formula that pulls the number from the cell to the right. {=B2}. It
works fine. I have 12 rows of data that I use the corresponging formucellal
reference. I then use sum above to get the total. Some formula results have
0 as the answer which is correct. However, the next formula needs to get an
average ignoring the 0s. I first tried to have the formula count the cells,
but it does not ignore the 0s. I tried this next
{=C14/if(C2:C13>0,count(C2:C13),0)}. Syntax error...any suggestions.
Kay
that might just be syntax, but I can't seem to solve it. first, in a table I
have a formula that pulls the number from the cell to the right. {=B2}. It
works fine. I have 12 rows of data that I use the corresponging formucellal
reference. I then use sum above to get the total. Some formula results have
0 as the answer which is correct. However, the next formula needs to get an
average ignoring the 0s. I first tried to have the formula count the cells,
but it does not ignore the 0s. I tried this next
{=C14/if(C2:C13>0,count(C2:C13),0)}. Syntax error...any suggestions.
Kay