Sum Formula Help

Options

Hi There,


I recently got some help on a countifs function but now i need to create a new formula on the same sheet.


I need add up the value of money in the 'predicted cost of incident' column between a certain date range, and also only when fabrication is selected under the 'Department Involved' column.

My current formula counts the number of rows between a date range and department which is:

=COUNTIFS([Date of Incident]:[Date of Incident], AND(@cell >= DATE(2023, 4, 1), @cell <= DATE(2023, 4, 30)), [Department Involved]:[Department Involved], "Fabrication")


Can this be modified at all?


Many thanks

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓
    Options

    Can this be modified at all?

    Try this:

    =SUMIFS([Predicted Cost of Incident]:[Predicted Cost of Incident], [Date of Incident]:[Date of Incident], AND(@cell >= DATE(2023, 4, 1), @cell <= DATE(2023, 4, 30)), [Department Involved]:[Department Involved], "Fabrication")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!