returning a value from a specific row to another specific row
 

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.

returning a value from a specific row to another specific row
 

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.

returning a value from a specific row to another specific row
 

=SUMPRODUCT(--(TEXT(A1:A100,"ddmm")="0105"),--(B1:B100="F"))
--
If this post helps click Yes
---------------
Jacob Skaria


"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.

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.