Formula Help - Sum the same dates as a value

[Thisisme_123]

Hello.

I need some help with a formula please - i am not even sure if it is possible? I need a formula that will add up the same DD/MM/YYYY in a column and return the sum of matching dates;

e.g

13/02/2020

16/01/2020

13/02/2020

13/02/2020

12/01/2020

11/01/2020

I want to calculate the number of '13/02/2020' that appear - and in the above example, the result would be 3.

Thank you

 

[BobbyConkers]

If the above are in A1:A6 use "=COUNTIF($A$1:$A$6,$A$1)" in column B against each one? It will do the same for each row, so you'd have three rows where column B has '3'. Is this what you're after?

 

[Thisisme_123]

Perfect thank you so much! Is it possible to add in multiple tabs within the formula? So it looks for the same date across multiple tabs?

 

[BobbyConkers]

It is. Use COUNTIFS instead, and you will set ranges as above, but just continuing on.

e.g. As above, =COUNTIFS($A$1:$A$6, $A$1, mytab1!$xy:$xy, $z, .......)

Basically add range,criteria on and on as you like. As you type it, go to the tab and choose the cells, it will fill in the range for you.

You can mix and match with COUNTIFS as well (e.g. choose how many 01/01/1900 here, plus how many 02/02/2020 there etc.)

 

[Thisisme_123]

Thanks BobbyConkers, although I am struggling to get it to work. I am getting value or too many arguments error.

I've created a googledocs, would you mind adding the formula in the yellow boxes in the first tab, calculating the dates in tabs 2, 3 & 4?

Day Count exercise.xlsx

drive.google.com

 

[BobbyConkers]

Ah, I see now. I've added them in, using the simplest method.

Basically, the first entry in the brackets is your range, the second "what it is looking for".

 

[Thisisme_123]

Works perfectly, thank you!