conditional reference
=sumif(A1:A7,"a",B1:B7)
or
=sumproduct(--(A1:A7="a"),B1:B7)
"Maarten" wrote:
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
|