Formula to return data from last row of a sheet of data

Jed Rusyniak

I am working on a dashboard and I'm using a intermediate sheet to collect data from other sheets of data.   Typically the data is entered in each day so I was able to have the formula for most cells to look at the referenced sheet and return the value for the row of data by date =SUMIFS({Incidents YTD}, {Yesterday}, "1").  The problem that I am running into is that some facilities don't update the sheet every day (including weekends) so on Monday's the formula doesn't work because it is looking for data from Sunday and there isn't any.  Is there a formula I could use instead that would just look at the referenced sheet and return values from cells in the last row of data?

Andrée Starå

Hi Jed,

We could maybe use an INDEX/COUNT combination formula.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I was also thinking an INDEX/COUNT would be a good solution.

 

A MAX function could also look at the date entries, but I feel like the INDEX/COUNT is going to be easier to put together.