# 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

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

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

Thanks for the quick reply Pete, it has worked

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

Glad to hear it - thanks for the rep.

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1