Easy to give you the sumproduct formula but google for

SUMPRODUCT:EXCEL
Post back if you still can't get it.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Blake_Allen" wrote in message
...
I am looking for a formula to retreive the sum within a column with
multiple
criteria.
I would like to be able to look totals for each day per shift.
Totals by day per shift would be great if possiable? I am struggling with
a
formula that looks at date (A) and also a shift (B) and sum all of the
cells
in (C) that have the correct shift by date.

Example:
column A column B column C
1 12/20/08 1st shift 10
2 12/20/08 1st shift 20
3 12/20/08 2nd shift 5
4 12/20/08 1st shift 10
5 12/21/08 3rd shift 10
6 12/21/08 1st shift 10

1st shift should total 40 for 12/20/08
2nd shift should total 5 for 12/20/08
3rd shift should total 0 for 12/20/08
etc...
If it matters this spread sheet will have approx 30000 rows?
It will be for a whole years data.

Thanks!
Blake_Allen