| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif on Formula instead of Value
You could use a helper column inserted to the right of your range and the GET.CELL macro. First define a name "ShowFormula" using the following reference. =GET.CELL(6,INDIRECT("RC[-1]",FALSE)) In the first cell of the helper column type the formula =ShowFormula and copy down your range. This will populate that with the formula of the cell to the left. Then you can use the COUNTIF funtion. So say your range to find the formula is A1:A10 and your helper column is B1:B10 then: =COUNTIF(B1:B10,"*CEILING*) Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=546764 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sumif formula with multiple critera | Excel Worksheet Functions | |||
| Getting Excel whilst using the sumif formula to search for part of a word | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| formula (perhaps sumif?) | Excel Discussion (Misc queries) | |||
| Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
Threaded Mode
