Hello everyone,
Just trying to get a Countifs to work for a table on income using dates.
I have the formula working for SUMIFS, and I thought all it would require is to paste formula and change SUMIFS to COUNTIFS, but apparently it's never that easy. Below is the formula as it stands now:
=COUNTIFS('Income'!$D:$D,'Income'!$A:$A,">="&DATE(2012,1,1),'Income'!$A:$A,"<"&DATE(2013,1,1))
Can anyone tell me what I'm getting wrong with this? Thank you
You probably don't want the reference to column D:
=COUNTIFS('Income'!$A:$A,">="&DATE(2012,1,1),'Income'!$A:$A,"<"&DATE(2013,1,1))
It would better to use cells to hold the dates:
A1 = 1/1/2012
B1 = 1/1/2013
=COUNTIFS('Income'!$A:$A,">="&A1,'Income'!$A:$A,"<"&B1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Since it's no longer a 'SUM', then you have to remove the 'RangeToSum' (D:D)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks