#### carltoninspired

##### New Member

I've been trying to figure out a simple solution to summing multiple columns (F:AC) whilst matching on criteria in column E.

i've tried =SUMPRODUCT(--(data1!E:E='Region Overview'!C4),data1!F:AC) however i get an error message saying "Excel ran out of resources" despite me having plenty of resources left available.

I've also tried =SUMIF(data1!E:E,'Region Overview'!C4,data1!F:AC) which only sums the values from the first column.

I know i could repeat the formula 24 times to sum each column individually but i have to do this so many times it would take forever.

I hope this is clear enough. Any help would be greatly appreciated as i've been trying to figure this one out for days now