Sum up to separate columns and show it in a single cell separately

Hi,

Please download the sample workbook first.

I want the formula for "B13" and "B14" on the basis of first table.
In B13 and B14 "/" means a sign or symbol not means diveded by.

My english is poor thats why it is difficult for me to explain, I hope you understand.


Thganks in advane.

You can put this formula in B13:

=SUMIF($A$3:$A$8,$A13,$B$3:$B$8)&"/"&SUMIF($A$3:$A$8,$A13,$C$3:$C$8)

then copy it into B14.

Hope this helps.

Pete

Your formula was correct.

But sorry its my mistake that I provided you with incomplete data. Please find the new updated data.

Thanks I solved my problem.
Appreciate you help.
Thanks for you time and effort.