• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Clarification for COUNTIF statment

S

sampath

Member
Hello,

Actual Data

In my excel ( Sheet1 ), Range A1 to A1000 having different date's from 1-Apr-2011 to 25-Apr-2015.

Required data

In same workbook ( Sheet2 ), Range B5 need how many of cells having after 1-Apr-2015 in Sheet 1(Total cells).

Please clarify the above requirement.

Regards,
Sampath.S
 
Hi Sampath,

you can use the simple COUNTIF in Sheet2 cell B5:

=COUNTIF(Sheet1!A1:A1000,">"&DATE(2015,4,1))

">"&DATE(2015,4,1)
is the criteria

Regards,
 
You must log in or register to reply here.
Back
Top