Help with greater than, but less than countif /sumif formula

[robertisforgiven]

Hello,

I am really having trouble figuring out how to do this and would greatly appreciate any help.

I have a column of data and I need to analyze ranges of numbers like this example:

10.2
5.1
2.6
11.6
5.7

I want to make be able to calculate for example (and eventually convert to charts)
*Total sum of all items that are less than 8, but greater than 3
*Total count of same

I get as far as calculating the "less than 8" part but cannot seem to discover how to have both qualifiers apply to one cell in one formula.

Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
how about

Book1
	H	I
8	10.2	10.8
9	5.1
10	2.6
11	11.6
12	5.7
Sheet1

Cell Formulas
Range	Formula
I8	=SUMIFS(H8:H12,H8:H12,"<8",H8:H12,">3")

And look at COUNTIFS for the 2nd part

 

[robertisforgiven]

Thanks! My misunderstanding in SUMIFS was that the range appears twice in the beginning of the formula. MUCH APPRECIATED for the insanely fast reply!

 

[Fluff]

You're welcome & thanks for the feedback