COUNTIF on NonContiguous Cells?
You seem surprised it did!! Thank's for the feedback
"RoadKill" wrote:
Wow, that works. Thanks!
"Mike H" wrote:
Try this
=SUMPRODUCT(--ISNUMBER(MATCH(COLUMN(C3:M3)-COLUMN(C3)+1,{1,3,5,7,9,11},0)),
--(C3:M3=1))
all in one line
Mike
"RoadKill" wrote:
Okay, so I think my issue with my COUNTIF is that the cells are not next to
each other. This is my range: (C3,E3,G3,I3,K3,M3).
What I want to do is range all the cells in that range that have data
equivalent to 1.00.
What I am thinking is =COUNTIF(C3,E3,G3,I3,K3,M3, "=1"). But unfortunately
that doesn't work.
Thanks
|