I have a 'dashboard' sheet and a 'log' sheet. I'm trying to pull data from the 'log' sheet and perform calculations on the data before displaying it in the 'dashboard' sheet. The 'log' sheet will have several hundred rows of data. Inside of the log sheet is a column for 'Task' and I will be using the data in the 'Task' column to locate other data that is related to the specific task.

The Problem

I'm trying to locate all of the instances of a specific activity, gather the hours spent on the activity (1 column to left), and then add up the total time spent on the activity (all instances) before displaying the total in the 'dashboard' sheet.

I've done a little reading about the DSUM and ArraySum, but I really don't know where to start with this problem. I know I can create new sheets for every 'task', populate the individual sheets using a QUERY statement, perform the necessary calculations in the individual sheets, and then pull data into the dashboard sheet. But I'm wondering if there is a single formula that I can use to accomplish my goal.


This is the document I'm working with.

Here is a video that explains the data needed and the problem I'm trying to solve.

Edit not from OP to include sections of two sheets:

log sheet

WA69084 first question example

Dashboard sheet

WA69084 first question example

The Dashboard sheet is after inclusion of a suggested formula in D36 and that copied up (ie part was not provided by OP).


1 Answer 1


In Dashboard D36 please enter:


(should result in the 19 you mentioned) and then copy up to D4.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.