I don't understand why SUMIF doesn't work

=SUMIF(A1:A7,"a",B1:B7)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Maarten" wrote in message
...
Dear all,

is there a way in Excel to get a range of cells as the result of a
conditional function? Like the SUMIF function, but without summing the
cells
(only their reference)
Say that I want to use all the values in column B for which the cells in
column A="a". The result in cell C1 should be the range B1:B4.
Is this possible?
A B C
a 11 if A1:A7="a" -- range (=B1:B4)
a 12
a 10
a 11
b 8
b 8
b 9