hi
i would like 3 formulas for countif
i would like to count all cells that contain a date in column A that is more than 30 days past the date in cell E1. i would also like to count all cells that contain a date in column A that is more than 3 days past the date in cell E1 (includes those over 30 days). i would then like to count all cells that contain a date 0-3 days more than the date in cell E1.
thank you
Try 3 below formula:
=COUNTIF(A:A,">"&(E1+30))
=COUNTIF(A:A,">"&(E1+3))
=COUNTIFS(A1:A4,">="&E1,A1:A4,"<="&(E1+3))
Quang PT
hi, thank you, for some reason it is bringing back a 0 value though??
Is there any chance to post a small example?
apologies, i'll open new thread.
Last edited by fabrecass; 01-22-2013 at 12:01 PM.
@fabrecass,
please open a new thread for your own query
here is the example
Originally Posted by bebo021999
The formulas that bebo021999 posted will do what you want.here is the example
In your sample file there are no dates that meet the first two conditions.
The formula for the third condition just needs to have the range address expanded:
=COUNTIFS(A:A,">="&E1,A:A,"<="&E1+3)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi, ok I see what I have got confused here. I meant to say OLDER than the date in cell e1 not past!! so it would be more than 30 days prior to the date in E1. Very sorry for this confusion, I will try the formula with a - instead of a +?
thanks
Ok, for dates OLDER than, try these:
=COUNTIF(A:A,"<"&E1-30)
=COUNTIF(A:A,"<"&E1-3)
=COUNTIFS(A:A,">="&E1-3,A:A,"<="&E1)
brilliant, thank you
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks