CountIfs not counting when using greater than or equal to

rhettblaine

New Member
Joined
Oct 3, 2013
Messages
29
Office Version
  1. 365
Platform
  1. Windows
Excel Formula:
COUNTIFS(t_data[Created],">="&Dashboard!$C$4,t_data[Created],"<="&EOMONTH(Dashboard!$C$4,0),t_data[Loan Type],"<>VA",t_data[Appraisal Reviewer Response],F7)

I'm using the formula above to count the number of accounts during the first and last day of the month the user selects. My data shows that I should have 12 accounts but the formula is only showing 11. I've noticed that the missing account is one that was created on the last day of the month (in this case, 11/30/22, if that matters).

I can correct this by adding +1 at the end of
Excel Formula:
"<="&EOMONTH(Dashboard!$C$4,0)
But, I'm just curious, does anyone know why this happens? The data is normalized. There's nothing that would cause the formula to skip the account.

This isn't an isolated issue either. I have seen this in the past where using CountIfs to count between dates will skip the last day of the range.

Thanks!
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Some of the dates in the Created column probably also contain a time element, so you need to check for < 1st of the next month.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top