Hi Domenic,

Thanks a lot for the alternative solutions - showing various ways to arrive
at the same end result. Very much appreciated.

With regard to headers: the data I'm using was extracted from another
worksheet and now starts in "Row number one" of each respective column, does
this mean the other two solutions are not viable if my data is in "Row number
one" of the worksheet?

Cheers
Sam

Domenic wrote:
Another way would be to use the column headings to choose the ones you
want evaluated. So, for example, if Columns B through J contain your
data, and the first row contains your headers/labels, try...

=SUM(MMULT((SUBTOTAL(3,OFFSET(B2:J10,ROW(B2:J10 )-MIN(ROW(B2:J10)),0,1))0
)*(B2:J10="North"),TRANSPOSE(ISNUMBER(MATCH(B1:J1 ,{"Header1","Header2","H
eader3","Header4","Header5"},0)))*1))

...where Header1, Header2, etc., are the headings for the columns you
want evaluated. Replace these with your actual headings.

or

=SUM(MMULT((SUBTOTAL(3,OFFSET(B2:J10,ROW(B2:J10 )-MIN(ROW(B2:J10)),0,1))0
)*(B2:J10="North"),TRANSPOSE(ISNUMBER(MATCH(B1:J1 ,L2:L6,0)))*1))

...where L2:L6 contains your list of column headings, indicating the
columns you want evaluated. Both formulas need to be confirmed with
CONTROL+SHIFT+ENTER.

In terms of efficiency, I don't know which one is more efficient. But,
personally, I prefer either of these two formulas as opposed to the one
I offer in my first post.

Hope this helps!

Hi Domenic,

[quoted text clipped - 25 lines]
Thanks
Sam


--
Message posted via http://www.officekb.com