BIGTONE559
Active Member
- Joined
- Apr 20, 2011
- Messages
- 336
Again having issues with syntax.
i have a column in which there are negative and positive numbers. i have the following criteria that need to be met, however, can't figure out how to "store" the number for a running sum.
and then this number will be displayed on Sheets("Summary").Range("T3")
As usual i appreciate all the help.
i have a column in which there are negative and positive numbers. i have the following criteria that need to be met, however, can't figure out how to "store" the number for a running sum.
Code:
if cell <0 and instr(1,cells(cell.row,5),"Blah blah")>0 then
'need code here to add the value of the current cell_
to a running total that's being calculated over the range.
and then this number will be displayed on Sheets("Summary").Range("T3")
As usual i appreciate all the help.