Hi,

I am trying to use one range criteria to sum 2 other ranges as follows:

FUNCTION(RANGE1, CRITERIA, [RANGE2 - RANGE3] )

SUMIF doesn't seem to allow multiple ranges in the 3rd section. I tried to use 2 consecutive SUMIF statements with a subtraction symbol between them but this counts all the empty cells as well for some reason. There must be an easier way to do this? HELP!

Thanks,
Sean