Need formula to populate total sales for each employee by month

Closed
Andre_a1234 Posts 1 Registration date Wednesday July 15, 2015 Status Member Last seen July 15, 2015 - Jul 15, 2015 at 03:54 PM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Jul 15, 2015 at 08:08 PM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Jul 15, 2015 at 08:08 PM
Andre_a1234, Good evening.

Try to use:

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