Hello ,
I have a question
I am trying to create a formula that is excuted as following:
I am working on 2 spreadsheets(tabs) named indicators and FNCI maj :
in spreadsheet 1 FNCI maj there are multiple dates from 2017 till 2021
in spreadsheet 2 indicators there are indicators where i am applying the formula
i want a function that could count the number of cells that contain the month march and are in year 2021.
So basically counting all the cells that contain a given month in a given year ,
i've been trying but without success
i tried using this formula
=SUMPRODUCT((MONTH('FNCI maj'!B2:B404)=3)*(YEAR('FNCI maj'!B2:B404)=2021))
Thanks for your help
I have a question
I am trying to create a formula that is excuted as following:
I am working on 2 spreadsheets(tabs) named indicators and FNCI maj :
in spreadsheet 1 FNCI maj there are multiple dates from 2017 till 2021
in spreadsheet 2 indicators there are indicators where i am applying the formula
i want a function that could count the number of cells that contain the month march and are in year 2021.
So basically counting all the cells that contain a given month in a given year ,
i've been trying but without success
i tried using this formula
=SUMPRODUCT((MONTH('FNCI maj'!B2:B404)=3)*(YEAR('FNCI maj'!B2:B404)=2021))
Thanks for your help