Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |