Thread: Count If Formula
View Single Post
 
Old 06-15-2011, 07:27 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Hi,

This formula will return a count where cells in column C have a date and cells in column D are blank:
Code:
=COUNTIFS(C:C,">0",D:D,"=")
Reply With Quote