Count range of cells if not next to each other

A

aaron85w

Joined
Sep 19, 2013
Messages
1
Reaction score
0
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

:bow::bow:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Number of Cells Q 5
COUNT IF NOT EQUAL TO ZERO 12
Using COUNTIF to find numbers within a range greater than the mean 2
Count if for # for how many cells contain a specific date range 4
SUBTOTAL Second Count / sub-count of Filtered Visible Cells 3
Count If Function 3
formula to count cells not blanK 4
counting entries in a range of data 1

Top