|
|
#4
11-02-2015, 02:58 AM
|
||||
|
||||
As written the formula looks for an invoice amount in column E. I mis-read your requirements. To have it for an invoice # in column D, use:
=IF(D7<>0,$H$1*(ROW()-MATCH("*",B$1:B6,-1)-1),"")
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formulato say if cell is blank do this, if not blank do this.
|
mbesspiata | Excel | 1 | 01-17-2015 05:02 AM |
|
How do you count how often a specific value occurs in single changing cell?
|
blackjack | Excel | 12 | 09-03-2014 10:41 AM |
| compare, match and count cell contents between sheets | bobsone1 | Excel | 11 | 08-07-2014 10:34 PM |
| won't show blank cell | bhum | Excel | 2 | 01-28-2014 02:34 AM |
|
How to count multiple values in a single cell, except zero?
|
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode