Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignoring fields containing text
I currently have a simple formula set up to calculate the outstanding sales
vaule for spcific operaions. Once the operation is complete the sales vaue is populated with the work 'COMPLETE' obviously the creates an error, so the formula has to be change so that is does not include this cell. As there are several hundrad cells in the formula and they are ever changing. Is there anyway I can get the formula to ignore the cells containing the word 'COMPLETE' and calculate the outstanding sales vaue automatically? Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignoring fields containing text
=sum(A1:A50) (as an example)
will ignore words in the range. -- Regards, Tom Ogilvy "TheRook" wrote: I currently have a simple formula set up to calculate the outstanding sales vaule for spcific operaions. Once the operation is complete the sales vaue is populated with the work 'COMPLETE' obviously the creates an error, so the formula has to be change so that is does not include this cell. As there are several hundrad cells in the formula and they are ever changing. Is there anyway I can get the formula to ignore the cells containing the word 'COMPLETE' and calculate the outstanding sales vaue automatically? Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignoring Text in a formula | Excel Discussion (Misc queries) | |||
Graph while ignoring text but not changing text to #NA | Charts and Charting in Excel | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Ignoring text and spaces ??? | Excel Programming |