G
Ginger
Hi,
Let say my data are as follows:-
A B C D
100 6 T 10'
200 7 E 15
300 6 D 10
400 5 F 20
500 6 T 11'
Question:-
I will sum up the numbers from Col D if the number in Col
B is "6" AND the text in Col C is "T". How do I come up
with this formula? Does sumif works here? If yes, how?
In this case, my answer should be 10 + 11 = 21.
Hope somebody can help me out here.
Thanks.
Let say my data are as follows:-
A B C D
100 6 T 10'
200 7 E 15
300 6 D 10
400 5 F 20
500 6 T 11'
Question:-
I will sum up the numbers from Col D if the number in Col
B is "6" AND the text in Col C is "T". How do I come up
with this formula? Does sumif works here? If yes, how?
In this case, my answer should be 10 + 11 = 21.
Hope somebody can help me out here.
Thanks.