In a sales quote sheet - sum totals by license type

[rbrown999]

Hello all,

I sell software and services of different license types (Perpetual, Term, SaaS, Implementation, and Training) that I want to sum by type. My spreadsheet looks like:

Column B Column C Column D Column E Column F
License Type List Price Discount Discounted Price Maintenance


I want to create a total for columns C, E, and F at the bottom that sums each row by the license/product type that's represented in column B.

TIA
Rob

 

[Claus Busch]

Hi Rob,

Am Wed, 24 Dec 2014 06:28:40 -0800 (PST) schrieb (e-mail address removed):

Column B Column C Column D Column E Column F
License Type List Price Discount Discounted Price Maintenance

the easiest and fastest way is a Pivot-Table.
Drag License Typ to the rows and List Price, Discounted Price and
Maintenace to the values.
If you want formulas then for "Training" and List Price:
=SUMIF(B:B,"Training",C:C)


Regards
Claus B.