MS Excel counting cells that meet criteria based to two conditions

Hi all,
I wonder if you could help me.

I have two columns of data. One column 'F' has the results of a calculation the other 'I' has the results of a count of a teams results. (I've attached a simple spreadsheet that represents this but not the actual one to keep things simple.) two-criteria.xls

I want to be able to count the cells in 'I' that have 1 in and it's corresponding value of 'F' range is between 0.5 and 1 for instance. I thought I could use a COUNTIF function but for the life of me I can't get it to work.

I've deleted out my attempts from the spreadsheet.

Any assistance would be gratefully received.

Dave
IrazorAsked:
Who is Participating?
 
FlysterConnect With a Mentor Commented:
You can use SUMPRODUCT:

=SUMPRODUCT(--(I:I=1),--(F:F >=0.5),--(F:F<=1))

Flyster
0
 
gowflowCommented:
Well I hope you have Excel 2007 and up as in this attached file.  You use SUMIFS
gowflow
Copy-of-two-criteria.xlsx
0
 
gowflowCommented:
If you want to include both 0.5 and 1 then in the formual you would change
">0.5" to ">=0.5" and
"<1" to "<=1"

gowflow
0
 
IrazorAuthor Commented:
This is excellent as it gives the result in one cell. Thanks.
0
 
gowflowCommented:
Sorry hv u tried my solution ?
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.