I'm trying to subtotal the values in a column (e.g. column A), based on what is filtered in column B (weekly total), and/or column C (monthly totals). For example, if week 13 is selected using the autofilter, it will calculate what is filtered and produce a weekly total based only on what is filtered. If I filter "all", it will add all of that column, and update monthly total as well. Can I do this without a macro? I'd like to know the best way to do this with and without a macro. The formula I have now doesn't calculate correctly when I filter a specific week.