function select – 2 catergories

2.78K viewsFormulas and Functions
0

Hi.

I have a problem with the function select attached.

Trying to get E3 in Matrix 2 = 11

Please help .

Attachments

sample 1.model
1

Hi,

Try to use this formula:

E3 = select( Matrix1::B1, @Matrix1::Year:Month, E1 & ":" & E2 )