Aladin Akyurek wrote:

In waht follows, A2:A5 houses the names data, B1:E1 the text data, and
B2:E5 the figures.

=SUM(IF($A$2:$A$5="Jim Smith",IF($B$1:$E$1="text1",$B$2:$E$5)))

which needs to be confirmed with control+shift+enter, not with enter.

Hi,

thanks a lot - this works great. I'm just learning excel
formulae/functions. Didn't know about the ctrl/shift/enter thing to
accept. Got this just in the nick of time - very much appreciated.

nelly