I am trying to make so if there is a 1 in c3:c32 then it counts it if there is a 2 in the same range I would like it to also count but only count 1 for every 2 if that makes any sense. is there a way to do this?
thanks in advance
I am trying to make so if there is a 1 in c3:c32 then it counts it if there is a 2 in the same range I would like it to also count but only count 1 for every 2 if that makes any sense. is there a way to do this?
thanks in advance
Try this:
=SUM(COUNTIF(C3:C32,{1,2}))
Does that help?
Regards,
Ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks