Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |