Posted to microsoft.public.excel.misc

Kathy L.[_2_] Kathy L.[_2_] is offline

external usenet poster

Posts: 16

Subtotal function with an If criteria

Hello,
If the following is example data:
A B C
1 Person $ Selected
2 Tom 10000 Y
3 Jack 15000 Y
4 Tom 20000 N
5 Tom 1000 Y
6 Jack 5000 N
7
8 51000

And cell B8 has the Subtotal(9,b2:b6) function, so I can sum based on a
filter on column A, is there a way to include a criteria in this subtotal
where Column C (selected) is Y?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
subtotal function using criteria	dbroc	Excel Worksheet Functions	5	January 10th 10 01:46 AM
Subtotal with additional criteria	Danni2004	Excel Worksheet Functions	1	April 23rd 08 08:45 PM
subtotal - multiple criteria	mdma	Excel Worksheet Functions	7	August 18th 05 05:19 PM
How do I nesting subtotal function within average function in Exc	Amy Yeh	Excel Worksheet Functions	4	January 19th 05 06:23 PM
SUBTOTAL and then count with criteria	Jane	Excel Worksheet Functions	3	January 13th 05 07:04 AM

All times are GMT +1. The time now is 10:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us