Q: Enter ID Value and Return the SUM of all ID sales (multiple sales entries)?

Ben, thank you for your prompt reply. I just figured out the SUMIF function as you were replying.

Now, I'm trying to build it across tabs. i.e. my report is on tab 1, and it has trailing tabs of Jan, Feb, Mar, April, etc. etc. Just to make sure it works.

Let me do some testing to validate and I'll either modify my original note to be more clear OR I'll come back and indicate it's solved. Thanks.

SOLVED
Used SumIF on array

Originally Posted by svance

I'm stumped.

I have salespersons who have multiple sales per day/month. Sure, I could do some filter sorting and subtotalling to determine each's total sales for the period, but... I have 35,000 sales people who may have as many as 100 transactions each per day. It's just not feasible (I think not feasible) to do filtering and subtotal

But my brain says, "Dang. I bet there's a way to do some kind of SUPER VLookup where I could just enter their ID and functions would find all their sales data AND sum it for the period in question."

Attached is a micro sample using three salespeople with just a few a sales each. PS I've attached an excel file example. Here you go

Raw data example
Day Emp Ident Sales
1 Sam 1111 143
1 Dave 2222 165
1 Sam 1111 137
1 Alice 3333 201
1 Dave 2222 106


Report out Format
Sales ID ####
Total Sales

For example if I entered 1111 it would return 280 (143+137). If I entered 222 it would return 271 (165+106)

Thanks you all