Count IFs not counting data correctly

dawidmns

New Member
Joined
Aug 5, 2022
Messages
8
Office Version
  1. 2013
Platform
  1. Windows
  2. MacOS
Hi

I have been trying to solve this for 2 days now without the luck.

I need to count "With QC - Trade" within last 30 days, then there will be other within 60 days, 90 days etc, but I need to sort out 30 days first.

I got this formula, data and calculation are on different tabs:

=COUNTIFS('Corporate Master'!F:F,"With QC - TRADE",'Corporate Master'!I:I,"<="&(NOW()-30))

So when I selected the data manualy, I got 11, and the formula counted 9, wham am I doing wrong?


1.png
 
That link comes back as "The selected transfer does not exist or has expired."
Hmm works on my side, have you clicked on the download in the middle, not the top one? the top one looks like an add.
 
Upvote 0

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
The sample file differs from the screen capture in your original post. Is this what you need?
Excel Formula:
=COUNTIFS('Corporate Master'!F5:F1458,"With QC - TRADE",'Corporate Master'!I5:I1458,">="&(TODAY()-30),'Corporate Master'!I5:I1458,"<="&(TODAY()))
 
Upvote 0
Solution
There is no download, in the middle of the page there is only this.
1659708141569.png
 
Upvote 0
You might have something blocking it, fluff, I was able to download it just fine after you mentioned there was a problem earlier. Just tried again on a different device and it's still working ok for me.
 
Upvote 0
You're right, tried it on a different browser & it was ok.
 
Upvote 0
The sample file differs from the screen capture in your original post. Is this what you need?
Excel Formula:
=COUNTIFS('Corporate Master'!F5:F1458,"With QC - TRADE",'Corporate Master'!I5:I1458,">="&(TODAY()-30),'Corporate Master'!I5:I1458,"<="&(TODAY()))
This is amazing, it works! thank you very much to all of you guys for your help. Really pleased with it, spent so much time trying to solve this issue!
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,218
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