# SUMIF with INDEX MATCH between 2 dates

1. ## SUMIF with INDEX MATCH between 2 dates

I have multiple stores within various town and want to be able to summarise the profits earned between two dates by town.

I’m using the formula
SUMIF(INDEX(\$C\$2:\$P\$7,,MATCH(A14,\$A\$2:\$A\$7,0)),\$C\$1:\$P\$1,”>=”&\$B\$10,\$C\$1:\$P\$1,”<=”&\$B\$11)
This is returning a VALUE error.

Below is how my worksheet has been set-up. I’ve seen similar queries on other threads but none of the solutions provided seem to fix my problem.

2. ## Re: SUMIF with INDEX MATCH between 2 dates

Try: =SUMPRODUCT((\$A\$2:\$A\$7=A14)*(\$C\$1:\$O\$1>=\$B\$10)*(\$C\$1:\$O\$1<=\$B\$11),\$C\$2:\$O\$7)

3. ## Re: SUMIF with INDEX MATCH between 2 dates

=SUMPRODUCT((\$C\$1:\$O\$1>=\$B\$10)*(\$C\$1:\$O\$1<=\$B\$11)*(\$A\$2:\$A\$7=A14)*\$C\$2:\$O\$7)

4. ## Re: SUMIF with INDEX MATCH between 2 dates

Both of these solutions work absolutely brilliantly. Thanks for the quick response.

5. ## Re: SUMIF with INDEX MATCH between 2 dates

You're welcome.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

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