=SUMPRODUCT((A1:A10={10,11})*(D1:D10))

"ekkeindoha" wrote:

I've got it like this
A B
30 2
11 3
10 4
11 5
13 6
10 7
What I would like to add up are the figures in B only if it shows 10 or 11
in A.
Hope this explain's better.
Thanks.



"Duke Carey" wrote:

Your description is very vague. Would you please state more clearly what you
are trying to do? Are you trying to add the cells in D1:D10 where the same
row has a 10 or an 11 in A1:A10?

"ekkeindoha" wrote:

Good day,
I would like to add up some figures with a formula.It must first lookup in
A1:A10 for 11 and add up all the figures in D1:D10, and also lookup in A1:A10
for 10 and add up all the figures in D1:D10

Thanks