Avgifs between dates

NickBlocker

Hi SmartSheet Gurus,

Not sure where I am going wrong here. I keep getting an unparsable error message

NickBlocker

@Paul Newcome thank you for replying back with a solution! I appreicate your partnership and quick reply. With your above information I was to get the formula to work. Formula I used is below :)

=AVG(COLLECT([TAT Days]:[TAT Days], Status:Status, "Complete", [Finish Date]:[Finish Date], >=DATE(2024, 1, 1), [Finish Date]:[Finish Date], <=DATE(2024, 12, 31)))

Paul Newcome

Happy to help. 👍️

Paul Newcome

AVERAGEIF is only designed for a single range/criteria set for filtering (in addition to the range to average).

For multiple range/criteria sets, you will need an AVG/COLLECT combo.

=AVG(COLLECT([Tat Days]:[Tat Days], Status:Status, @cell = "Complete", .......................................))

NickBlocker

@Paul Newcome thank you for replying back with a solution! I appreicate your partnership and quick reply. With your above information I was to get the formula to work. Formula I used is below :)

=AVG(COLLECT([TAT Days]:[TAT Days], Status:Status, "Complete", [Finish Date]:[Finish Date], >=DATE(2024, 1, 1), [Finish Date]:[Finish Date], <=DATE(2024, 12, 31)))

Paul Newcome

Happy to help. 👍️