Match Multiple Criteria

[Abhijeet]

Hi

I have data in that match multiple criteria i.e Assignment & Element if both match then give Units i have tried with vlookup but if more than 1 same value then this will not work in that case i want to highlight that Assignment number & add up that Units

please tell me how to do this

 

[Abhijeet]

Hi

I tried with this its work but apart from any method & how to highlight more than 1 same criteria

Please tell me

=IF(SUMIFS($D$3:$D$14,$B$3:$B$14,$G10,$C$3:$C$14,H$2)=0,"",SUMIFS($D$3:$D$14,$B$3:$B$14,$G10,$C$3:$C$14,H$2))

 

[PCosta87]

Hi,

Something like this perhaps (see attached)
Highlighted orange when more than one match is found.

Hope this helps

 

[Abhijeet]

Good one i also tried same thing