Price list SUBTOTAL

[m1d11]

Hi,

EXCEL.png

Is there a quick way to get the grand total (yellow box) without having to calculate the individual total first (blue box)?

[bebo021999]

Try:
=SUMPRODUCT((B2:B5)*(C2:C5))

[m1d11]

Excellent!! Thank you very much!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.