COUNT fx help needed

[brose99]

I need help with the following COUNT fx

----A---------B--------C

1--1.9-------1
2--1.8-----------------1
3--1.6-----------------1
4--1.4-----------------1
5--1.2-------1
6--0.9-------1

I need to count the number of 1's in column B as long as the range in column A is between 1 and 2.
I also need to count the number of 1's in column C as long as the range in column A is between 1 and 2.

Thanks!

 

[Joe4]

You can use COUNTIFS, which allows you to count with multiple conditions.

Your first formula would look like:

=COUNTIFS(B1:B6,"=1",A1:A6,">=1",A1:A6,"<=2")

I will let you figure out the second. It will be a good test to make sure you understand COUNTIFS.
Here is a link, if you need it: https://www.techonthenet.com/excel/formulas/countifs.php

 

[jtakw]

Hi,

Book1
	A	B	C
1	1.9	1
2	1.8		1
3	1.6		1
4	1.4		1
5	1.2	1
6	0.9	1
7
8	Results	2	3
Sheet195

Cell Formulas
Range	Formula
B8	=COUNTIFS(B1:B6,1,$A$1:$A$6,">=1",$A$1:$A$6,"<=2")
C8	=COUNTIFS(C1:C6,1,$A$1:$A$6,">=1",$A$1:$A$6,"<=2")

 

[dreid1011]

Perhaps this:


=COUNTIFS($A$1:$A$6,">=1",$A$1:$A$6,"<=2",B1:B6,1)

 

[brose99]

Thanks for your replies everyone! I had to step away but will test these out tonight when I can get back to my excel workbook. I appreciate all of your help!!!

 

[jtakw]

You're welcome, glad to help.