Sumifs by name by period

[BRISBANEBOB]

I am trying to sum the transactions by time period by name. I've got most of it done except for the final step which is in the array colored yellow. I've attached a sample. Thanks for all help received.

[truk2]

To make it easier to read I converted your transaction list into a table object (ctrl + t)
This means that your formulas won't need to be updated as you add extra lines of data.

I also got rid of your hour extraction and added a helper column "time" to the table using formula

Please Login or Register  to view this content.

To count transactions per hour, I just used the time in the given row as the start time, and the time in the next row as the end time of the period. Countifs formula:

Please Login or Register  to view this content.

the sumifs formula in the table per person was

Please Login or Register  to view this content.

To make it easier to fill across I made the table references absolute

Please Login or Register  to view this content.

These formulas also work with standard range references, but I like tables better. Let me know if you need any of this explained more

[BRISBANEBOB]

Hi Truk

You have given me the sum of the total value of Transactions which I also have to do, so you've solved that issue for me!

I explained myself badly - I also need to allocate the actual number of transactions which is column P. I extended the table to include that, but I still can't get the number of transactions by name by period. Does that explain it any better?

Thanks for your help

[juddaaaa]

I think this is what you're looking for

Please Login or Register  to view this content.

[BRISBANEBOB]

That is the solution originally sought and I thank you, juddaaaa.

Truk, I have also incorporated your solution and I thank you.

Kind regards

[juddaaaa]

You're very welcome

[truk2]

You are welcome.
Sorry I wasn't online to answer you again. juddaaaa gave the same solution I would have given.