I am building a template and trying to sum based on the combination of store and category. (see attached screen shot) Column "O" is where I am trying to return the values of grid in range (A1:K14) Please let me know your thoughts. [IMG]excel.jpg[/IMG]
Hi I am not able to see the attachment. Please re-attach the file. Regards Uday
Please attach the excel file and not a picture. thanks
Hi I am simple excel file with name and amount payable. Names may be repeated in excel rows. I want to total amount if name is repeated.