Hi
I would like to count the number of times a 3, 6, or any multiple of 3 appears in a cell. Can any one help
Thanks
Hi
I would like to count the number of times a 3, 6, or any multiple of 3 appears in a cell. Can any one help
Thanks
what's in the cell
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Please try this file.
Last edited by ramananhrm; 09-06-2013 at 07:59 AM.
Please click 'Add reputation', if my answer helped you.
Thanks. it entered 1 when i reached 3 but went to zero for any number greater than 3
Please give some examples - what data do you have, what resuls do you expect?
Audere est facere
Cell L8 counts when there is an entry in A8-H8. When L8 reaches 3,6,9 or any multiple of 3, I want M8 to show the total multiples of 3. at3 total is 1, at 6 total is 2 etc
Try this formula in M8
=INT(L8/3)
That works perfectly.
Thank You
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks