=SUMPRODUCT(--(A2:A100=1),--(B2:B100="a"),C2:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mdma" <mdma.1twqme_1124280381.0864@excelforum-nospam.com> wrote in message
news:mdma.1twqme_1124280381.0864@excelforum-nospam.com...
>
> i have a sheet, which i want to sub total on two levels..
>
> for example, i have a product number, country code, and value. The
> sheet is sorted by product number then country code.
>
> i require totals for the value of the product (which i can acheive by
> using the sub total function), but also require a further total for
> upon change in country code with the the product number :
>
> product number country value
> 1 a 5
> 1 a 10
> *subtotal 15*
>
> 1 b 15
> *subtotal 15*
>
> Total 1 30
>
> 2 c 20
> *subtotal 20*
>
> Total 2 20
>
>
> --
> mdma
> ------------------------------------------------------------------------
> mdma's Profile:
http://www.excelforum.com/member.php...o&userid=24284
> View this thread: http://www.excelforum.com/showthread...hreadid=396421
>