G
Guest
Using a spreadsheet with the following format:
A B C
1 JEFF MONDAY $5.00
2 LISA MONDAY $10.00
3 LISA MONDAY $5.00
3 JEFF TUESDAY $15.00
I need a formula in column E and F to calculate how much each person sold on
a certain day. If this is true, and this is true, sum this....
D E F
MONDAY TUESDAY
1 JEFF $5.00 $15.00
2 LISA $15.00 $-
THANK YOU!!!
TMF
A B C
1 JEFF MONDAY $5.00
2 LISA MONDAY $10.00
3 LISA MONDAY $5.00
3 JEFF TUESDAY $15.00
I need a formula in column E and F to calculate how much each person sold on
a certain day. If this is true, and this is true, sum this....
D E F
MONDAY TUESDAY
1 JEFF $5.00 $15.00
2 LISA $15.00 $-
THANK YOU!!!
TMF