Thread: sumif
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default sumif

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.

....

Another alternative,

=SUM(SUMIF(A1:A6,{10,11},B1:B6))