| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of cells and total in one column, based on another column suffix
Have in column C values, some of which end in =T.
I have data in columns D through H some values(numbers). I'd like to do two things: Obtain the number of cells that are in each column that have a corresponding value that ends with a =T in column C. Also, obtain the total of the values of the cells in each column, also of which have a corresponding value that ends =T in column C Tried messing with sumproduct, but haven't hit on the right formula. TIA for thoughts. Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count number of highlighted cells in column | Excel Discussion (Misc queries) | |||
| Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
| Count entries in one column based on values in another column | Excel Worksheet Functions | |||
| Can you count the number of cells that are highlighted in a column | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
Threaded Mode
