In a sales quote sheet - sum totals by license type


R

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
 
Ad

Advertisements

C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top