Sumproduct with Year


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

Leave a Reply

Your email address will not be published. Required fields are marked *