Posted to microsoft.public.excel.worksheet.functions

Bec

external usenet poster

Posts: 15

Sumproduct Subtotal

I have the following formula and would like to use a subtotal, can anyone help?

=SUMPRODUCT((O21:O10060)*(N21:N1006=0)*($C21:$C10 06))

Essentially the formula is counting addition of vehicles in the current
month. i.e. Counts if the col O0 and col N equals 0

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
Sumproduct Subtotal #Value! error	Graham	Excel Worksheet Functions	2	February 20th 09 02:46 PM
Another SUMPRODUCT SUBTOTAL question...	Bob Phillips[_3_]	Excel Worksheet Functions	4	January 19th 09 03:55 PM
nesting sumproduct with subtotal	SteveDB1	Excel Worksheet Functions	9	August 27th 08 11:38 PM
Sumproduct and subtotal	Marcelo	Excel Worksheet Functions	1	March 21st 07 03:26 PM
Subtotal - Can I use Sumproduct ?	guilbj2	Excel Discussion (Misc queries)	4	May 30th 05 10:40 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us