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.
Bookmarks