Results 1 to 3 of 3

Thread: Formula Help -

  1. #1

    Smile Formula Help -



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I am new here and am looking for help with a formula.
    I am a set designer and need to keep an eye on production costs.
    I have created a multi tab worksheet : Excell file.xlsx

    On the second sheet named Back Up, I will be entering purchased item amounts to keep an eye on the budget.
    Under the 'Item' column I have created a drop down list:
    Assistants
    Production
    Set Build
    Props


    Is there a formula I can add to the pink 'budget' boxes on the righthand side, to calculate the costs on each line?
    For instance if I have added a cost for assistants in the left hand sheet, and selected form the drop down list 'assistants' the box on the right will automatically calculate every cost with assistants as an 'item'?

    I know I can manually add these costs but it would be great if there would be an auto calc.

    Thank you for your help in advance!

    I hope this make sense!

    Many thanks!

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    824
    Articles
    0
    Excel Version
    Excel 2010
    I believe the function you are looking for is SUMIF.

  3. #3

    Little Help

    Please see file attached

    You can change the range on the formula to be the entire E & F columns
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •