how do you divide the results of countif() by a number in the same formula:
sum(countif(a1:a20,"=1"))/123
How do I make it work?
Thanks
how do you divide the results of countif() by a number in the same formula:
sum(countif(a1:a20,"=1"))/123
How do I make it work?
Thanks
Try
=Countif(A1:A20,1)/123
Thanks. perfect!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks