Hello, can you help me write a formula using LOOKUP or IF or something else, I'm at a loss, or maybe it can't be done.
I want to calculate the value from a column (A) but only add values from rows if set conditions are met in column B and column C
so the formula wirtten in a cell in List 1 will use values from columns in List 2, which has 3 columns:
////AAA BBB CCC
1 7 4.1 f
2 15 4.2 g
3 5 4.2 i
4 89 4.3 g
5 6 4.2 g
So basically, if I choose to combine for instance the value "4.1" with "g" then I want to sum up the values from column A, but only those which have the value "4.1"in column B and the value "g" in column C.
I thought LOOKUP would be the best but it doesn't seem to want to combine 2 columns.
I started with =LOOKUP("4.1";List2!I:I;SUM(List2!G:G)) but that's only the 1 value in 1 column + it's not even working, anyone has an idea?
Marianka
Bookmarks