# SUMIF formula for count of other column between 2 numbers?

1. ## SUMIF formula for count of other column between 2 numbers?

Hi there,

Please see below for a formula that is returning - when a value should appear:

=SUMIF(D11:D273,">=1""<=30",C11:C188)

Basically, column D is a column with aging days.
column C is a column with amounts due for the aging days.

What I want the formula above is to come up with is to sum up all amounts (from column C) where the aging days from column D is between 1 and 30.

Any advice where I am going wrong?

Regards

Nim  Register To Reply

2. ## Re: SUMIF formula for count of other column between 2 numbers?

You have two conditions, so you will need to use SUMIFS, like this:

=SUMIFS(C11:C273,D11:D273,">=1",D11:D273,"<=30")

Note that the ranges need to be the same size.

Hope this helps.

Pete  Register To Reply

3. ## Re: SUMIF formula for count of other column between 2 numbers?

Thanks for the quick reply Pete, it has worked   Register To Reply

4. ## Re: SUMIF formula for count of other column between 2 numbers?

Glad to hear it - thanks for the rep.

Pete  Register To Reply