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