problems on application of Matrix Multiplication / Product sum functions

Dear all

I am having some problems with two tables, one is related to species (column) vs traits (row) and the other one is related to sites (column) vs species (row).
I would like to have a third matrix traits (column) vs sites (row) by matrix multiplication or or the sum of products functions. I have alraedy applied the matrix multiplication function but it results in value error. I send data as annex to get some help from you, if possible.

Thank you

Sincerely

Jose Macedo

Maybe you can post an small example of the desired result.

Thank you for the comments. I will see those aspects you referred. thanks

Hi,

What exactly are you trying to do here? What are your expected results?

Regards

Hello again
I have already changed the arrays. However I only can get a result for the first multiplication. The others result in value error when I drag the cells. Can you see please which could be the problem when dragging the cells?
Thank you

But you still haven't told us what the results should be (?)

Regards

I have two arrays: one with species and the values of traits for each one. Other is related to data of each species per site.
I would like to have, per site, data relative to traits.
Ex: In site X 10 plants (5 from plant A, 3 from plant B and 2 from plant C). Plant A is a blue plant, plant B is red and plant C yellow.
So, I would like to quantify, per site, each one of the characters (traits): blue, red, yellow.
I hope this help
Thanks

But in your attachment there is no mention of "plant A", "plant B" "plant C", "blue", "red" or "yellow", just a series of values on two sheets.

Perhaps, as oeldere said as far back as post #2, you could manually enter some of your expected results into the spreadsheet and tell us how you arrived at those results.

Regards

I send I new file more simple
please find data 3 (2) file
regards

I send I new file more simple
please find data 3 (2) file
regards

another example

Maybe with an pivot table.

See the attached file.

ok thank you very much
I will see right now
thanks again