| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct and subtotal
hi,
I would like to know, if is possible to combine sumproduct and subtotal, eg =sumproduct(--(a2:a1000="rev")*(b2:b1000="jan");(subtotal(9,c2:c 1000)) regards -- regards from Brazil Thanks in advance for your feedback. Marcelo |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct and subtotal
What are you trying to do by combining?
SUBTOTAL() returns a single value, so this would multiply the subtotal by the number of dual matches: =SUMPRODUCT(--(A2:A1000="rev"), --(B2:B1000="jan")) * SUBTOTAL(9, C2:C1000) But that may not be your intent In article , Marcelo wrote: hi, I would like to know, if is possible to combine sumproduct and subtotal, eg =sumproduct(--(a2:a1000="rev")*(b2:b1000="jan");(subtotal(9,c2:c 1000)) regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| SUMPRODUCT and (perhaps) SUBTOTAL with AUTOFILTER | Excel Worksheet Functions | |||
| SUMIF SUBTOTAL OR SUMPRODUCT? | Excel Worksheet Functions | |||
| Subtotal - Can I use Sumproduct ? | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
