SUMPRODUCT QUESTION

[rki1966]

I am using the sumproduct to count the cells with multiple criteria, but my formula has a another formula in it. If I take the (AB$38&"-"&$AG204&"-L") out and put the results into another cell it works but I do not want to do it that way because it uses a lot of cells. Any suggestions?




SUMPRODUCT(--(ExpCode=(AB$38&"-"&$AG204&"-L")),--(MKTVAL>0))

 

[Aladin Akyurek]

Are you saying that the formula yields an incorrect result?

And does this return the expected result:

SUMPRODUCT(--(ExpCode=(TRIM(AB$38)&"-"&TRIM($AG204)&"-L")),--(MKTVAL>0))

 

[rki1966]

IT DID NOT WORK

 

[Brian from Maui]

IT DID NOT WORK

What did not work? Did it return an unexpected value, error messages etc...