Forum Discussion
counting dates
I 've got a file from https://cneos.jpl.nasa.gov/fireballs/ I removed all columns but the first one. The first column shows the dates when a fireball was observed. I need to arrange it in this fo...
=SUMPRODUCT((MONTH($A$2:$A$926)=C4)*(YEAR($A$2:$A$926)=B4))You can try this formula which returns the expected results in my sheet.
- Thank you. Can you send me the spreadsheet?
You are welcome. Here you are.
