• 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.

Count / Countif and Countifs

rbobcat1

Member
I wrote a formula to count a column only if it meets the right dates but all I get is a 0 zero

formula
=COUNTIFS(Sheet1!I:I,">="&Sheet2!$D$2,sheet1!H:H,"<="&sheet2!$G$2)

I need to count I if it falls between the dates in H

the dates are entered on sheet 2 cells d2 and g2

my formula above returns a 0
 
Back
Top