Sum Formula Help

James Brett

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

Carson Penticuff

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")

Carson Penticuff

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")

James Brett

Hi Carson,

This works perfectly thank you