Countifs formula to only count 'Last month'
-
-
-
What's different to the formulas that I provided last week?
-
Hi royUK, last week I wanted everything counted prior to last month.....now I only want data counted during last month. I thought I could tweak your formula, but I can't get it to work.
-
Try this
=COUNTIFS(Table1[Response Received],"Yes",Table1[Notice Remedy Date],">=" &$E$1,Table1[Notice Remedy Date],"<=" &EOMONTH($E$1,0))
-
Excellent royUK . Works perfectly, cheers.
-
-
Pleased to help.
Post back if you need further help.
Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!