Thread: [Solved] Count if another cell is blank
View Single Post
 
Old 11-02-2015, 02:58 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,362
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote