| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
criteria
This is a formula I am using
=sumif(D13:D328,1,F13:F328) so I am checing if any cells from d13 to d328 have a 1 in them and if so to total the sum of F13 to F328 ie d14,20 and 23 have a one in so sum f14,20 and 23. I want to add a check so I check for a 1 in d13 to d328 and e13 to e328 to then sum f13 to f328 this doesn't work =sumif(D13:D328andE13:E328,1,F13:F328) |
| 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 | |||
Threaded Mode
