Hello all,
I am completely stuck with a formula in Excel 210 right now!
I'll give you a bit of background of what I am trying to do. I need to count the number of cells that are equal to '1' within ranges C175 & C177:C190 & C200:C280.
I have tried the formula below, however it doesn't work as the ranges are not together.
=COUNTIF('IDS BFR''s'!C175,'IDS BFR''s'!C177:C190,'IDS BFR''s'!C200:C280,"1")
Can anyone provide any assistance or provide a function that would work in this case?
Thanks very much
I am completely stuck with a formula in Excel 210 right now!
I'll give you a bit of background of what I am trying to do. I need to count the number of cells that are equal to '1' within ranges C175 & C177:C190 & C200:C280.
I have tried the formula below, however it doesn't work as the ranges are not together.
=COUNTIF('IDS BFR''s'!C175,'IDS BFR''s'!C177:C190,'IDS BFR''s'!C200:C280,"1")
Can anyone provide any assistance or provide a function that would work in this case?
Thanks very much