| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM of column based on format criteria
I need to sum a column which has a series of dollar amounts, some the same,
but only include numbers once they have been made bold. eg 23.50 67.80 (Bold format) 99.45 88.23 23.50(Bold format) 22.45 88.23 19.00 In the above example the sum would be only of numbers with bold format. What would e the formula to do that Thanks SRN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum specific column rows based on 2 different column criteria | Excel Worksheet Functions | |||
| Counting items in one column based on criteria in another column | Excel Worksheet Functions | |||
| filter or format based on criteria in more than one column | Excel Worksheet Functions | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Threaded Mode
