| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
criteria
you might also want to look at just creating a pivot Table report under the
data menu. -- Regards, Tom Ogilvy "merjet" wrote: Then use =SUMPRODUCT(--(D13:D328=A1),--(E13:E328=B1),F13:F328) where A1 and B1 reference cells containing whatever values you want to test. Hth, Merjet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
| Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| have input box. Need criteria entered to refer to cond. format criteria | Excel Programming | |||
Hybrid Mode
