Extracting datas to use it in SUMIFS
A question about SUMIFS function.
In my formula below, the SUMIFS function shows the 1st test value $Année du séjour. The 2nd test is $ Mois du séjour
Each one refers to 2 hidden columns where we find a number representing the year, and the other one the month extracted from a "date" column.
The couple Month/Year I refer to is the one in the pink case of the Periode column.
1) This way to do things is rather complicated because it assumes I have created first the 2 columns where we find numbers related to year, and month.
I'd rather prefer to go and check directly the "date" column i'm refering to, watching for the year, and then the month. Something like this ... :
In this picture the "date" column is in brown.
But obviously SUMIFS has a problem with it; it says: in the SUMIFS function, all interval type values must have same size
Am I missing something, or is it really impossible to use another function to extract the value to test ?
2) Since I have 2 conditions to verify at the same time, is there a special way to use AND function in SUMIF or SUMIFS ?
Thanks all for your help and time.
Lionnel
iMac, OS X Yosemite (10.10)