hi, i need a formula at H1 to count the zeros(o) which apreared in line a t F1:F21.thanks
hi, i need a formula at H1 to count the zeros(o) which apreared in line a t F1:F21.thanks
Maybe this?
In H1
=COUNTIF(F:F,0)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
thanks alkey,but i need it from below,so if any other number apears in F:F ,like at F6 , H1 formula should show zero(o)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks