Countif & Vlookup

[mickiey]

Hi there
can any please help with this request;

i have a date say in "A1" which is gotten from a Vlookup from say dates in column"C", this works fine. however i am trying to use the date in "A1" to count the amount of dates in say column "E" which are before the date in "A1" but i keep getting 0 which i know is incorrect, if i reference the date which is not from the vlookup but manually enterd into another cell then it works, any suggestions.

mickiey

 

[mickiey]

Hi there this is what i have;
In cell (L3) i have a date of the 29/03/2013
In cell (L4) i have a date of the 05/04/2013
there are hundreds of in the sheet but i just need the total in between the two dates which is (124) not (-124)

does this make sense, sorry if i have ddouble sent the message

 

[Aladin Akyurek]

Hi there this is what i have;
In cell (L3) i have a date of the 29/03/2013
In cell (L4) i have a date of the 05/04/2013
there are hundreds of in the sheet but i just need the total in between the two dates which is (124) not (-124)

does this make sense, sorry if i have ddouble sent the message

That is: L3 <= L4. Given that:

=COUNTIF(C:C,">"&L3)-COUNTIF(C:C,">="&L4)

=COUNTIFS(C:C,">"&L3,C:C,"<"&L4)

 

[mickiey]

Hi there, yes that works (you know there will be a but) i need the formula to include the actual dates given and not between, sorry to be a pain.

many thanks

 

[Aladin Akyurek]

Hi there, yes that works (you know there will be a but) i need the formula to include the actual dates given and not between, sorry to be a pain.

many thanks

Try...

=COUNTIF(C:C,">="&L3)-COUNTIF(C:C,">"&L4)

=COUNTIFS(C:C,">="&L3,C:C,"<="&L4)

 

[mickiey]

Thats it many thanks for all your help, you guys are amazing

 

[Aladin Akyurek]

Thats it many thanks for all your help, you guys are amazing

You are welcome. Thanks for providing feedback.