SUM values when criteria matches more than one cell

**ABSTRAKTUS** · 12-10-2010, 02:28 PM

Hi all,

This one will be really easy. There are 2 columns in a table:

A B

9-12-10 25
9-12-10 36
9-12-10 42
9-12-10 14
10-12-10 28
10-12-10 44
10-12-10 13
11-12-10 22
11-12-10 28
11-12-10 36
11-12-10 52

How do I sum values for each day?

Thanks a lot!

**ChemistB** · 12-10-2010, 02:36 PM

in I4

=SUMIF($C$4:$C$31, $H4,D$4:D$31) dragged right and down
Does that help?

**ABSTRAKTUS** · 12-10-2010, 02:42 PM

Thanks. It works.
But, this was part 1. Part 2:
Now I need to calculate weekly results. Part 1 is daily report, Part 2 - weekly. How do I get round this?

**ChemistB** · 12-10-2010, 03:53 PM

How are you going to set up your weekly reports; with monday's date? or 2 cells, start and end? Does it involve weekends at all or just Monday-Friday? If it does involve weekends, is it Sun - Sat or Sat - Fri?