Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a Sum but involves Text & multiple functions
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help me! making table involves percents | Excel Discussion (Misc queries) | |||
IF/Nesting When Calculation Involves a Date | Excel Worksheet Functions | |||
Functions, Arrays and number/text stored as text | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Change text within multiple functions | Excel Worksheet Functions |