validation of three conditions in three columns and then adding up from the 4th

  • Thread starter Thread starter tajammul faheem
  • Start date Start date
T

tajammul faheem

could anyone out there can help me with the following.

I have created an excel worksheet with following columns
Sn name CA/PS LS/SS CA Size Qnty
1 XYZ CA LS XL 2
2 XYZ CA SS L 2
3 XYZ PS LS XXL 2
4 XYZ PS SS M 2

i want to validate 3 columns ie CA/PS LS/SS CA Size
eg if CA/PS=CS and LS/SS=LS and CA Size=XL(all in the
range of rows) then it should sum from the Qnty column

Your help and assitance will be highly appreciated

thanks
tajammul
 
Hi
try
=SUMPRODUCT((C2:C999="CS")*(D2:D999="LS")*(E2:E999="XL"),F2:F999)
assuming that row 1 is a heading row
 
Back
Top