G
Guest
Does anyone know how to do a SUMIF which will allow you to enter two ranges
which apply to two sets of criteria? For example, I have the following data,
and I would like to write a formula that will sum for me the red Ds only.
(answer = 3)
colour letter amount
red F 3
orange D 5
yellow B 4
purple E 2
red D 3
orange B 5
yellow E 4
purple F 2
I normally write this in two steps, but I wonder if it is possible to do it
all in one formula?
which apply to two sets of criteria? For example, I have the following data,
and I would like to write a formula that will sum for me the red Ds only.
(answer = 3)
colour letter amount
red F 3
orange D 5
yellow B 4
purple E 2
red D 3
orange B 5
yellow E 4
purple F 2
I normally write this in two steps, but I wonder if it is possible to do it
all in one formula?