I know how to use SUMIF OR SUMPRODUCT but this one got me badly. I have the following columns of data: customer name, item description and sales by week # (the item description can repeat for different customers). I need to find the total sales for a particular customer name and item description knowing the week number. INDEX and MATCH would not work because there are two conditions. What to do then? Please help. Thank you. Tony.