Sumproduct returns a blank cell when I use following formula in the year column =TEXT(A1,”YYYY”)
It DOES recognise =TEXT(A1,”MMMM”) in the Month column.
I can get it to work by using =JAHR(A1)) however I would really like to know why sumproduct can work with the month formula but doesn’t recognise the year if I use =TEXT(A1,”YYYY”)
Would be very thankful for an answer 🙂
By: Deirdre Dooey