Countif and sumif columns based on another cells as parameters

Hi,

Hoping someone could give me a hand, I know this is just a simple formula and i might actually just missing a thing or two here.

So the problem is this, based on the attached file, I have a list of figures in column H.

And what I need are formulas for column D3 to E5 that will return the ff :

For column D - Count of figures in column H where the value is less than or equal to the amount in cell C3 ;
- Count of figures in column H where the value is equal to the amount in cell B4 but less than the amount in cell C4;
- Count of figures in column H where the value is greater than or equal to the amount in cell B5.

For column E - Sum of figures in column H where the value is less than or equal to the amount in cell C3 ;
- Sum of figures in column H where the value is equal to the amount in cell B4 but less than the amount in cell C4;
- Sum of figures in column H where the value is greater than or equal to the amount in cell B5.

As the values in cell B3 to C5 might change from time to time, I would have wanted the formula to reference those cells.

I hope this makes sense. And than you in advance for the help! Godbless!

Try these:

D3 =COUNTIF(H:H,"<="&C3)
D4 =COUNTIFS(H:H,">="&B4,H:H,"<="&C4)
D5 =COUNTIF(H:H,">="&B5)

E3 =SUMIF(H:H,"<="&C3)
E4 =SUMIFS(H:H,H:H,">="&B4,H:H,"<="&C4)
E5 =SUMIF(H:H,">="&B5)

Hi 63falcondude ,

This works perfectly, thank you so much!

You're welcome. Thanks for the rep!