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