View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TMF in MN
 
Posts: n/a
Default If then with 2 criteria, then sum

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