Forum Discussion
How to aggregate the drop down list items to get the category-wise sum?
Hi,
Please see the attached file. I am trying to calculate the costs in terms of categories (services) from drop down lists. Sheet 3 is the final sheet to show the calculated results based on the data from sheet 1 and 2. Is there any way to combine the results of different categories in the final sheet?
Thank you very much for taking the time.
Best regards,
Tooba
10 Replies
Hi, its me again. Hope you are doing well.
Please check the attached file. I need to fix the price of one task from a list for all the staff members this time. Previously, the total was calculated according to staff's rate per hour, but now I need to include one task at fixed price for all the staff members.Can you please have a look if it can be done?
Thank you very much for your time.
Best regards,
Tooba
MTooba I'm sure it is possible if enough information is known. Right now you have a table with person and rate, and a table with person, hours, tasks and $$ based on previous table. You want to fix the rate for a given task but you don't have a table that defines rate for a given task. You also want person to get their rate for 'other' tasks but don't define what that is. For example this excerpt from the table:
Staff Task # Hrs Total Jerry Janitorial 4 440 Mac Janitorial 12 420 Julia Janitorial 3 240 each of these staff do Janitorial and I think you want to 'fix' the rate but at what amount? Each of them have different rates.
- Thank you very much. It is really helpful. The formula with C6:C10 works well.
