SUMIF Criteria range to be taken automatically

Originally Posted by JohnTopley

@XOR LX

SUMIF (for me) did not work over a range i.e range which was not single column or single row: maybe I was doing something wrong?

Apologies. You're perfectly correct. I didn't read the question properly.

Regards