formula required

[deck-b]

Hi all


I need a formula that can recognise the common demonators below and then add based on this common demonator. Please see the below - the bolded numbers are where i need the formala. Basically its to recognse where a and b are in the top table and then add the numbers in the second table.

Please help!

Thanks

Declan

jan feb mar months is a months in b
1 a a b 2 1
2 a a b 2 1
3 a a b 2 1


jan feb mar total of a total of b
1 5 5 10 10 10
2 5 5 10 10 10
3 5 5 10 10 10



this view is not showing what it should. i can forward a screen shot if someone is willing to help!

 

[repkos]

As far as I understand you, this array formula should be the solution:

=SUM((A6:C6) * ((A1:C1) = "a"))

where A6:C6 are cells A1:C1 from your second example table (5, 5, 10), and A1:C1 are cells A1:C1 from the first table (a, a, b).
This should help with column D, for column E replace "a" with "b".
Remeber to use it as array formula, i.e. paste the formula to the cell and press Ctrl + Shift + Enter.

Let me know if it works.
Regards