Subtotals based on value in other cell

boydr · Apr 29th, 2002, 07:41 PM

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.

Anne Troy · Apr 29th, 2002, 07:53 PM

Perhaps you just need a sumif?

boydr · Apr 30th, 2002, 05:25 AM

I tried a sumif, but can't get it to work if I filter for only 1 week. Any ideas?

Aladin Akyurek · Apr 30th, 2002, 06:08 AM

Quote:

On 2002-04-30 04:25, boydr wrote:
I tried a sumif, but can't get it to work if I filter for only 1 week. Any ideas?

That would indicate that you don't have a column in your data area which houses week numbers.

If you want to, post 10 rows of your data you're autofiltering: Activate an empty cell, type =, select 10 rows of data including the labels, hit F9, Copy what you see, and post the copied bit here in an follow-up posting.

Apr 29th, 2002, 07:53 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Perhaps you just need a sumif? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 07:41 PM	#1
boydr Board Regular Join Date: Apr 2002 Location: Arkansas Posts: 157	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.

Apr 30th, 2002, 05:25 AM	#3
boydr Board Regular Join Date: Apr 2002 Location: Arkansas Posts: 157	I tried a sumif, but can't get it to work if I filter for only 1 week. Any ideas?