I need some help....

If i have a worksheet and i want to pick out anything in column N that has a
value of "TR" and then return the value of the data that is on the same row
but in column P can this be done?? Does that make sense??

"DisFUNCTIONAL" wrote:

I need some help....

If i have a worksheet and i want to pick out anything in column N that has a
value of "TR" and then return the value of the data that is on the same row
but in column P can this be done?? Does that make sense??


I think I had the same ? and this is the answer I was given. (Worked great)
=SUMIF(N1:N15,"TR",P1:P15)
Also, pick out of column N and O (Where ANY is the value, for example) and
return P
=SUMPRODUCT((N1:N15="TR")*(O1:O15="ANY")*(P1:P15))