Previous Topic Next Topic

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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response