Please help!
 

Need help on this problem:

SM(A) PROD (B) REV (C)

MAT PSP1004K 2395
MAT PSPWIPEOUT 499
MAT PSPLUMINES 399
MAT PCLDVD25MINUS 79
MAT PCLDVD25PLUS 158
MAT VERBATIM43432 39
MAT OPTIOWP 3292
MAT OPTIOWP 3292
MAT OPTIOWP 3292
MAT OPTIOWP 3292

Which formula is best used to summerize the revenue (REV) for these
conditons; SM= MAT, PROD=OPTIOWP ?

Thanks for your help!

Regards,

Giganten


--
Giganten

Giganten Wrote:
Need help on this problem:

SM(A) PROD (B) REV (C)

MAT PSP1004K 2395
MAT PSPWIPEOUT 499
MAT PSPLUMINES 399
MAT PCLDVD25MINUS 79
MAT PCLDVD25PLUS 158
MAT VERBATIM43432 39
MAT OPTIOWP 3292
MAT OPTIOWP 3292
MAT OPTIOWP 3292
MAT OPTIOWP 3292

Which formula is best used to summerize the revenue (REV) for these
conditons; SM= MAT, PROD=OPTIOWP ?

Thanks for your help!

Regards,

Giganten
Do you realize you are asking this question in an Excel discussion
group? You may need to pose this as an Excel question then. Where are
the formulae?


--
jahoobob

Try:

=SUMPRODUCT((A1:A1000="MAT")*(B1:B1000="OPIOWP")*( C1:C1000))

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"Giganten" wrote in message
...

Need help on this problem:

SM(A) PROD (B) REV (C)

MAT PSP1004K 2395
MAT PSPWIPEOUT 499
MAT PSPLUMINES 399
MAT PCLDVD25MINUS 79
MAT PCLDVD25PLUS 158
MAT VERBATIM43432 39
MAT OPTIOWP 3292
MAT OPTIOWP 3292
MAT OPTIOWP 3292
MAT OPTIOWP 3292

Which formula is best used to summerize the revenue (REV) for these
conditons; SM= MAT, PROD=OPTIOWP ?

Thanks for your help!

Regards,

Giganten


--
Giganten