Summing ranges of criteria

[nvrstl]

I am trying to create a table that sums a range of numbers from a column using COUNTIF. I have successfully formatted single digits but need to sum criteria between to ranges. i.e between 31-60 days or 61-90 days, etc. Is this the correct formula?

 

[VoG]

Try like this

=SUMIF(A1:A100,">=31")-SUMIF(A1:A100,">60")

 

[T. Valko]

I am trying to create a table that sums a range of numbers from a column using COUNTIF. I have successfully formatted single digits but need to sum criteria between to ranges. i.e between 31-60 days or 61-90 days, etc. Is this the correct formula?

What version of Excel are you using?

 

[nvrstl]

2007

 

[T. Valko]

2007

Try this...

Book1
	A	B	C	D	E
2	20	_	31	60	3
3	72	_	_	_	_
4	10	_	_	_	_
5	40	_	_	_	_
6	51	_	_	_	_
7	85	_	_	_	_
8	81	_	_	_	_
9	71	_	_	_	_
10	69	_	_	_	_
11	84	_	_	_	_
12	15	_	_	_	_
13	31	_	_	_	_
14	65	_	_	_	_
15	65	_	_	_	_
Sheet1

Formula entered in E2:

=COUNTIFS(A2:A15,">="&C2,A2:A15,"<="&D2)

 

[nvrstl]

Thanks - both replies got me to the answer - many thanks!

 

[T. Valko]

Thanks - both replies got me to the answer - many thanks!

Good deal. Thanks for the feedback!