| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a function for this?
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
is there a function for this?
=SUMPRODUCT(--(B3:D3="x"),B$2:D$2)
HTH -- AP "cindyb" a écrit dans le message de news: ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
