Rob,

=SUMPRODUCT((D13:D328=1)*(E13:E328=1)*(F13:F328))

HTH,
Bernie
MS Excel MVP


"Rob" wrote in message
...
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)