Help with Functions

  • Thread starter Thread starter DisFUNCTIONAL
  • Start date Start date
D

DisFUNCTIONAL

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 said:
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)
Click to expand...
=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))
 
Back
Top