wilbursdad
New Member
- Joined
- Dec 26, 2008
- Messages
- 7
I use a countif statement and find the number of times a cell contains a value in an entire sheet.
Now each time it does find the value I want it to Sum the $ amount of these occurances that is shown in another cell. Each time the value appears, the formula would have to look in the previous column. If that cell is formatted as currency that is the value. If it is not it needs to keep moving down (a maximum of 4 cells) one cell at a time until it finds a currency value and then that is it. Does anyone have any ideas?
Now each time it does find the value I want it to Sum the $ amount of these occurances that is shown in another cell. Each time the value appears, the formula would have to look in the previous column. If that cell is formatted as currency that is the value. If it is not it needs to keep moving down (a maximum of 4 cells) one cell at a time until it finds a currency value and then that is it. Does anyone have any ideas?