Hello,
I am trying to use a =sumifs formula where the criteria range searches to infinity (B:B), but then looks one row offset for the criteria. The purpose is to look at the date paid (column A) and sum the amount paid if in USD (Column J). The payment type (eg USD) is labeled in Column I. payment Column I & J are one row down from the the date paid.
for example:
=SUMIFS(J:J,A:A,TODAY(),I:I,"USD") works because there is no offset
But =SUMIFS(J:J,offset(A:A,-1,0),TODAY(),I:I,"USD") does not work because of the offset
however, =SUMIFS($J2:$J1000,OFFSET($A2:$A1000,-1,0),TODAY(),$I2:$I1000,"USD") works, but I need the formula to sum to infinity.
Anyone have any ideas?
Thanks!
Bookmarks