Perhaps:
=C2+SUMPRODUCT({10,5},--(E2:F2<""),LEN(E2:F2)-LEN(SUBSTITUTE(E2:F2,",",""))+1)


"v!v" wrote:

Hi - Trying to turn a simple informational table into a math question here.
The initial table includes the following which were initially handentered:
(First row headings)
col A-G
NameOfPayer Check# MembershipAmount MemberName LlamaRegistered@$10ea
LlamaEntered@$5ea CheckTotal
(2nd row data)
Thompson 2214 $30.00 Thompson Denali Denali $45.00
(3rd row data)
Hester 345 blankcell blankcell blankcell Tigger,Blackie $10.00
Now the table is getting large enough, that the trial manager wants to
calculate the totals after he puts in the rest of the data as a double check
to what the check should have been made out for. I need to come up with that
formula that generates the total as the data is entered. Some basic facts:
Membership is always $30 per person, a lifetime Llama registration is $10 so
they don't have to be registered every time they enter a pack trial, trial
entry fees are $5 per animal every time, & multiple animals can be entered in
a single trial.
The total(G2) needs to be the sum of C2 plus E2 plus F2. E2 equals $10 x
number of animals recorded in that cell and F2 equals $5 x number of animals
recorded in that cell; animal names are separated by commas.
Any ideas?

Thanks



--
Thanks