Help with Array Formula

[Tonyjstone]

Hi All,
I have a spreadsheet which is a general file of expenses with one of the columns being 'Description'. In order to analyse the cumulative values I use an array formula which sums the values by description.
{=SUM(($C$1:$C$80)*($D$1:$D$80=D88))}
One of the descriptions is uniformly preceded by variable dates and transaction numbers which prevent my array formula from selecting and summing correctly.
Could anybody help me to modify my formula so that it will see the 'identifier name' which sits in the 'Description' text string.
The 'Description' string is usually 50 to 70 characters and the 10 character string I need to identify is usually 10 or 12 characters in.

 

[GlennUK]

Why don't you have an extra column with a formula to get just the descriptor from the descriptor column, and then use that in your array formula?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Tonyjstone]

Hi Glenn,
That may be my only viable choice. Thanks for the response.

Remember, half the people you know are below average.

 

[01Patrik]

Seems to me that you need to combine VALUE with MID and FIND, something like this:

=value(mid(yourref,find(identifier,yourref),1))



// Patrik