Sum of multiple dates

[RFalch]

Hey there,

I have a list of sales rep and their sales on any given date. My problem is this: I would like to see the total sales (sum) for each sales rep on a any given date. In the attached file i would like to make the table on the right look like the table on the left.

It can easily be done manually by taking the sum of sales for each sales rep on each day. However, this is practically not feasible as i got thousands of rows. I would like to know if it is possible to make one formula which i could drag out for all rows and then have end up with the table on the left side.

[boopathiraja]

Hi, Welcome to the forum,

Try this in G2 and drag it down,

Please Login or Register  to view this content.

Note : Extent the ranges as per your req...

[RFalch]

That worked!

Thank you so much!

[boopathiraja]

Hi, Thanks for the feedback If your Query Solved, You can mark the thread as solved and (preferably) say thanks to those who helped by clicking the Add Reputation button.

[RFalch]

Marked the thread as solved and added +rep on your user, thanks again.