sumproduct

[kmrowlan]

I am wanting to do the sumproduct but only if column (F) is > 0. How would I incorporate that into the formula below?


SUMPRODUCT(--('BACKCHARGE DATA'!$I$2:$I$1143="NV Distribution, "),--('BACKCHARGE DATA'!$K$2:$K$1143>=$A$27),--('BACKCHARGE DATA'!$K$2:$K$1143<$A$28)

 

[VoG]

Try

SUMPRODUCT(--('BACKCHARGE DATA'!F$2:F$1143>0),--('BACKCHARGE DATA'!$I$2:$I$1143="NV Distribution, "),--('BACKCHARGE DATA'!$K$2:$K$1143>=$A$27),--('BACKCHARGE DATA'!$K$2:$K$1143<$A$28)

 

[kmrowlan]

thank you....that worked perfectly