| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting only values
I am currently using a formula (without using VB) that offsets the lookup on
a row: =OFFSET(X5,COUNTA(X:X)*1,-1) I had to add a formula to that same range that is only visible if there is data from whe it is pulling from. How do I make the above formula (or make a different formula) look at only the value of the cell not the contents of the formula. The contents of the current cell in the range: =IF('sheet7'!N18="-","",'sheet7'!N18) Thanks for any help with this! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Values amongst #N/As | Excel Worksheet Functions | |||
| Counting values in one cell based on values in another | Excel Discussion (Misc queries) | |||
| counting rows with same values for multiple values | New Users to Excel | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting Rows Then Counting Values in Columns | Excel Programming | |||
Threaded Mode
