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
Bookmarks