is there a function for this?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone help me with the following?

My spreadsheet looks like this

term ins whole ins variable life total
points
6000 11500 18000
Joe Client x
John Doe x x

I want the "total points" column to calculate the total value of all the
columns with an "x" in them. So for Joe Client, I would need the total
points to be 6000 and for John Doe, I would need the total points to be
calculated as 29,500. Is it possible for the total points column to
calculate the points for just the columns that I would put an "x" in? If so,
how do I do this? Any help is greatly appreciated!
 
You must log in or register to reply here.

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

Similar Threads

Adding certain cells in one column 4
Formula for totaling selections 6
Minusing 17.5% off a column of figures 2
How do I calculate a specific formula for price increases? 3
Formula for calculating YTD values 3
Count if cetain text is in another column, same row. 6
How to ignore a column of numbers in Grand Total for rows 1
What is the most straightforward (elegant) way to write this formu 5

Back
Top