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
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 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
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
Andre_a1234, Good evening.

Try to use:

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!