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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

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,113,823
Messages
5,544,538
Members
410,619
Latest member
gregor222
Top