Need formula to populate total sales for each employee by month

Closed
Report
Posts
1
Registration date
Wednesday July 15, 2015
Status
Member
Last seen
July 15, 2015
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
Hello,

Im working on a spreadsheet and i cant come to a formula that works for me.


I want to total the amount of apples each employee sold each month. So i need a return value of in Jan - Bob 53, Jane 59, Brian 62, Jon 52, Kathy 53. Feb return value be Bob 64, Jane 52, Brian 43, Jon 38, Kathy 66.

Image provided.
Thanks
A

1 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
Andre_a1234, Good evening.

Try to use:

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão