How do i write a formula to calculate YTD totals of a given category
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
Best Answer
-
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())
Answers
-
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())
-
ah. perfect. thanks! Works perfect.
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!