=SUMIF(A$2:A$199,D2,C$2:C$199)
Right now if A:A Matches ,D2 it will give me C value.
What i need to do is the same above but only bring back value for column C. if Columns B and Column E match also to.
I need to put this all together somehow and if it all matches bring value back from Column C.
Any help thanks.
=SUMIF(A$2:A$199,D2,C$2:C$199)
=SUMIF(B$2:B$199,E2,C$2:C$199)
Right now if A:A Matches ,D2 it will give me C value.
What i need to do is the same above but only bring back value for column C. if Columns B and Column E match also to.
I need to put this all together somehow and if it all matches bring value back from Column C.
Any help thanks.
=SUMIF(A$2:A$199,D2,C$2:C$199)
=SUMIF(B$2:B$199,E2,C$2:C$199)