How do i write a formula to calculate YTD totals of a given category

steve50951

Here is the formula i started with. It gives me a #unparceable response

=SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row), Date:Date, YEAR(@cell) = YEAR(TODAY()))

Ive included a screen shot

Paul Newcome

You just have too many parenthesis tucked away. Give this a try...

=SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row, Date:Date, YEAR(@cell) = YEAR(TODAY())

Paul Newcome

You just have too many parenthesis tucked away. Give this a try...

=SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row, Date:Date, YEAR(@cell) = YEAR(TODAY())

steve50951

ah. perfect. thanks! Works perfect.

Paul Newcome

Excellent! Happy to help! 👍️

Please don't forget to mark the most appropriate comment as the "Accepted Answer" so that others know a solution has been found.