Adding more arguments to SUMPRODUCT

[ddub25]

=IF(SUMPRODUCT(--([CasScalp_MAS_110416.xlsx]Acounts!A10:A742=E11),--([CasScalp_MAS_110416.xlsx]Acounts!F10:F742=$AF$8)),"X","Y")

I have the above fully working formula, but want to add more IF's:

1) That IF C10:C742 (on [CasScalp_MAS_110416.xlsx]Acounts!) = "B" (as well as E11 matching A10:A742 and $AF$8 matching F10:F742), then return a "B" instead of an "X".

2) And IF C10:C742 (on [CasScalp_MAS_110416.xlsx]Acounts!) = "S" (as well as E11 matching A10:A742 and $AF$8 matching F10:F742), then return a "Y" instead of an "X".

Any ideas on including these. Thanks.

Dan

 

[baitmaster]

this looks like an array formula set to return only a single value, is this right? Or do you have this set on a number of cells within an array?

If single value, can you not stick a IF(countif(range,"B")>0, condition in front of it

For advanced features of sumproduct, look at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[jasonb75]

See your original thread

http://www.mrexcel.com/forum/showthread.php?t=544084

 

[ddub25]

thanks jason, I've just posted a reply to the original.