A BC D PINK TROSE 150PINK TROSE 150REDTROSE 150
SUMMARY
BLACKRED PINKCASHROSE 0150300450LILY0000ORCHID0000Total0150300450
How I can set up the formula with above answer ?
thanks
更新1:
sorry your formula not worked, I am not able to download your file from the web
更新2:
i used "SUMIFS" , it worked on version 2007 but not worked on 2003. When I open the file on 2003. formula auto added "_xlfn.". if updated data under 2003, cells becine "#NAME". Please advise how to solve this problem thanks