# Sum between dates for a specific column and specific time frame

1. ## Sum between dates for a specific column and specific time frame

Hi,

Thank you for reading this. I have attached a sample data sheet to this post.

2 formulas needed:

1- I am trying to sum data for a office for the current year. (All 2019)

2-Then I am trying to sum data for the previous year through same time frame. (1/1/2018 - 10/20/2019)

I can use this =SUMIF(A2:A9,"<="&D14,INDEX(B2:D9,,MATCH(D13,B1:D1,0))) to get the total sum for correct column -but I need to get the date range implemented for them.

-David  Register To Reply

2. ## Re: Sum between dates for a specific column and specific time frame

C16=sumproduct((year(\$a\$2:\$a\$9)=year(\$c\$14))*(\$b\$1:\$d\$1=\$c\$13)*(\$b\$2:\$d\$9))

c17=sumproduct((\$a\$2:\$a\$9<=\$c\$14-(52*7))*(\$b\$1:\$d\$1=\$c\$13)*(\$b\$2:\$d\$9))  Register To Reply

3. ## Re: Sum between dates for a specific column and specific time frame

CARACALLA

Thank you so much! Works great.   Register To Reply

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