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