AND in array formula

D

damezumari

{=SUM(E13:AE13*IF(TEXT(E$7:AE$7,"mmmm")=mes,1,0))} gives 15.05767168


{=SUM(E13:AE13*IF(AND(TEXT(E$7:AE$7,"mmmm")=mes,TRUE),1,0))} gives 0

mes is the range name for a cell that contains the name of a month.

The top array formula works as expected, but why does the bottom one
give 0. It should give the same result as the top one as I have only
added TRUE in an AND condition.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top