[SOLVED] Sumif trouble

Hi All,

I am trying to get a sum total for ONLY unique Order Totals in Sheet 2, for Unique Name & Week combinations in Sheet 1. For example, for the Cell in Column F, , for all occurences of John week 1 in sheet 1, I need to include the sum of John Week 1 from sheet 2 ONLY ONCE, in an aggregate sum of all other unique name/week combinations as in sheet 1.

In Column F highlighted green, I need ONE single unique total value of all items from Sheet 1. I suppose this uses some combination of COUNTIF and SUMPRODUCT/SUMIF but i have not figured this out.

For the example in the sheet for all names, the answer im looking for should be 6200. Not 12400


i'LL APPRECIATE SOME HELP

Edit/Update: This has been solved

Hello visk92,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

Administrative Note:

Please post in the correct forum. Thank you