Need Help With SUMIF formula

Roseanne Gerringer

Hi all,

Hope this question makes sense... I am trying to create a formula that will sum the amount of CME in one row if the date of CME activity falls between a specified date range indicated by a set of dates stored on a row...

Example want to sum CME totals from Echo Specific CME column that fall within the appropriate triennium specified in last 2 colums.

Thanks,

Roseanne

Paul Newcome

Try something along the lines of...

=SUMIFS([Column to Sum]:[Column to Sum], [Course Name]:[Course Name], CONTAINS("Echo", @cell), [Date of CME]:[Date of CME], AND(@cell >= [Beginning of Triennium]@row, @cell <= [End of Triennium]@row))

Paul Newcome

Try something along the lines of...

=SUMIFS([Column to Sum]:[Column to Sum], [Course Name]:[Course Name], CONTAINS("Echo", @cell), [Date of CME]:[Date of CME], AND(@cell >= [Beginning of Triennium]@row, @cell <= [End of Triennium]@row))

Roseanne Gerringer

Thank you so much!

Paul Newcome

Happy to help! 👍️