Many thanks Bob, but I still struggled to get that to work. Waht I do have is
not elegant at all. Any ideas?

This seems to work:
=IF(ISERROR(SEARCH("4k",Hosts!$E10)),0,Hosts!$E13) +IF(ISERROR(SEARCH("4k",Hosts!$F10)),0,Hosts!$F13) +IF(ISERROR(SEARCH("4k",Hosts!$G10)),0,Hosts!$G13) +IF(ISERROR(SEARCH("4k",Hosts!$H10)),0,Hosts!$H13) +IF(ISERROR(SEARCH("4k",Hosts!$I10)),0,Hosts!$I13) +IF(ISERROR(SEARCH("4k",Hosts!$J10)),0,Hosts!$J13) +IF(ISERROR(SEARCH("4k",Hosts!$K10)),0,Hosts!$K13) +IF(ISERROR(SEARCH("4k",Hosts!$L10)),0,Hosts!$L13)

"Bob Phillips" wrote:

Is the 6 a text field, if so, use quotes.

--
HTH

Bob Phillips

"DC" wrote in message
...
Thanks Bob, but I seem to missing something here.
The resuilt I get for the formula (against the named array) is 0 where I
expect a 3. Am I missing something here?

"Bob Phillips" wrote:

=SUMPRODUCT(--(ISNUMBER(FIND("4k",1:1))),--(3:3=6),4:4)

--
HTH

Bob Phillips

"DC" wrote in message
...
4k 16bit 4k 16bit 4k 10bit 4k 16bit HD 4:4:4 N/A N/A N/A
76.48 76.48 50.9 76.48 8.29 0 0 0
6 25 25 6 0 0 0 0
1 1 1 2 0 0 0 0
458.88 1912 1272.5 917.76 0 0 0 0

Hi I have a table and I want to do the following:
Parse table "CResults" row A for any "4k*" with a condition of "6" in
row
3
and if true "sum" all instances in row 4.
All data is in CResults.

Your help appreciated