Thread
:
sumif
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
external usenet poster
Posts: 733
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))
Reply With Quote
Harlan Grove
View Public Profile
Find all posts by Harlan Grove