Sum if, but the sum range is seperate cells ?

[Ainsley]

I want to do a simple Sum if.

My range is simple and so is my criteria, but the actual range of cells to sum is not in one continus row or column. Can I do the sumrange as seperate cells ?

Cheers

[Cheeky Charlie]

Don't think so.

Maybe make your sum range a separate column or row which collects the various sources into the right order...

HTH

[Domenic]

Can you specify which cells you wish summed and the condition on which it's based?

[Ainsley]

Hi, I think I will put the cells to sum in a different place then do my sum if on that instead.

Thanks