Totaling cells based on values of reference cell?

[SHCOCS]

I have a spreadsheet that tracks the amount of a specific item someone purchases on a specific date. What I am interested in is how do I total, in 1 line, the amount someone (in this case, John Smith), buys?

I know I can sort the column by purchaser name and highlight the total and just get the total from that but I would prefer something more automated.

Bonus option 2 would be to get a total of how many of each item each purchaser bought in the year as well, I tried a pivottable but given the amount of items I have, it's might not be feasible.

Thank you in advance

 

[mrshl9898]

Can you show some example data and desired results?

Pivot Table is the first thought I had, it shouldn't matter how big the data is.

 

[SHCOCS]

Knew I was forgetting something. Basically I just want to know how many items (in total is fine, how many of each individual may be unrealistic/not worth the time since there are 60+ items) each purchaser orders.

 

[mrshl9898]

What I am interested in is how do I total, in 1 line, the amount someone (in this case, John Smith), buys?

Isn't this the 500 shown?

Bonus option 2 would be to get a total of how many of each item each purchaser bought in the year as well

From the sample data.

C7 = 01/01/2018
C8 = 31/12/2018
D7 = "John Smith"
E7 = "=SUMIFS(C:C,B:B,D7,A:A,">="&C7,A:A,"<="&C8)"

I'd pivot it though, add a year column =YEAR(A3), then the pivot will have year in the filter, name and sum of Total Ordered

 

[SHCOCS]

Yes, the 500 is the total amount in that particular, I should have said how much he ordered in the entire year, as a purchaser could order multiple times per year and I could have multiple purchasers. It would be much easier for me to have a single line showing total for the year rather than counting up. I think pivoting is probably the way to go, thanks for your input.