I hate being thick.
Could someone please tell me how to make a count of a list of 12 cells
say a3 to m3 as long as the value of each cell is 9.
eg if all are 9 except b3 then result would be 11.
Many thanks
sorry for being stupid.
I hate being thick.
Could someone please tell me how to make a count of a list of 12 cells
say a3 to m3 as long as the value of each cell is 9.
eg if all are 9 except b3 then result would be 11.
Many thanks
sorry for being stupid.
=countif(a3:m3,9)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks