returning a value from a specific row to another specific row
hey, thanks a lot! it works!!
"Sheeloo" wrote:
enter this in C9
=SUMPRODUCT(--($A$8:$A$12=A8),--($B$8:$B$12=B8))
and copy down...
It will give you the count for the combination of values in Col A and B in
that row.
You can also list unique combinations in another place and use that
reference in place of A8 and B8.
"kyoko" wrote:
i really need help on this one. i don't know if it's possible but i still
want to try.
here's the case:
A B
row8 01- May F
row9 01-May D
row10 01-May F
row11 01-May F
row12 02-May F
in this case, i want to return how many "F" on 01-May only. i hope there's a
specific formula for this one. it's a really big help if there is...thanks in
advance.
|