concatenate issue

[Cossie]

Hello everyone can anyone help me with this problem. I want to put a ' / ' between the results of the formula below. Any advice on where to put it so that the formual works. Thanks

=CONCATENATE(SUMPRODUCT((INDIRECT('Data Page'!$B$3&"!$g$2:$g$925")=$A$2)*(INDIRECT('Data Page'!$B$3&"!$K$2:$K$925")=$A5)*(INDIRECT('Data Page'!$B$3&"!$w$2:$w$925"))),SUMPRODUCT((INDIRECT('Data Page'!$B$3&"!$g$2:$g$925")=$A$2)*(INDIRECT('Data Page'!$B$3&"!$K$2:$K$925")=$A5)*(INDIRECT('Data Page'!$B$3&"!$w$2:$w$925"))))

The result should look like 15 / 25.

Thanks for you assistance

 

[Ron Morris]

Hi,

After your first set of parentheses and comma, you should be able to enter as follows:


$925")))," / ",SUMPRODUCT(etc.....

Hope this helps.

Ron

 

[Cossie]

Thanks Ron