I need help changing current SUMIF formula to grab data from 1 sheet to 3 sheets.

Options

I currently use a SUMIF formula to pull costs from a summary timecard and it places it in a Total Cost from timecard column in a master management sheet. I believe I just have to modify it so the formula sees the 3 different sheets. Please take a look at the attached PDF that explains it a bit more. I have been researching the formulas handbook and believe I might need to consider SUMIFS or something like that to create a string.

Best Answer

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Answer ✓
    Options

    @dennis.goudy72296

    =SUM(SumIF(),Sumif(),Sumif())

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!