Sumif with multiple criteria problem

[nellyc]

Hello Gurus

In the attached on the quote tab in cells G5 & H5 i have two formulas both trying to pick up the data from the highlighted matrix in the frame tab.(i only need one)

From the dropdowns in cells F1, F3 & F5 in the quote tab I wish to get the data from the matrix in the frame tab cell range C3 - F20

Can someone please explain where i am going wrong.

Thanks

Nelly

[canapone]

Hi,

in G5

Please Login or Register  to view this content.

Hope it's a little help

[Pepe Le Mokko]

Perhaps something like

Please Login or Register  to view this content.

[nellyc]

It helped a lot, thank you

I see where i went wrong now.

[nellyc]

It helped a lot, thank you

I see where i went wrong now.

[canapone]

Ciao,

thanks for you kind feedback.

Regards