Trying to show previous time period data based on an INDEX / MATCH function

stevan_

New Member
Joined
Jul 4, 2014
Messages
14
Hi all.

Basically I've created a function that the user can select 2 dates to show a date range (Match) and then return the sum of data within those dates.
Code:
=INDEX(data!$U$9:$U$374,MATCH(dashboard!$L$8,data!$Q$9:$Q$374,0)):INDEX(data!$U$9:$U$374,MATCH(dashboard!$X$8,data!$Q$9:$Q$374,0))

This works well but now I'd like to also show the previous time periods sum of data (so a count of days would be needed).
I'm pushing my limits of knowledge here - possibly an array function would be needed?
PS has to work for excel 2010 and no VBA due to security concerns.

I was thinking on the lines of using DAYS and a countif but im getting lost on the complexity of thought.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

earthworm

Active Member
Joined
May 19, 2009
Messages
368
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Kindly share sample here with end results that you require
 

Watch MrExcel Video

Forum statistics

Threads
1,114,314
Messages
5,547,148
Members
410,775
Latest member
alal1030
Top