sumproduct #na

Hi everyone, i have function that counts based on week, year and another criteria. =SUMPRODUCT(--(WEEKNUM(Table1[Date]+0,21)=[@Week]),--(YEAR(Table1[Date]+0)=[@Year]),--ISNUMBER(SEARCH("BBB",Table1[Items]))). Is it possible to have this formula ignore rows that has text in column A, between...

Hi all, I have a data in Table 1 looking like below and I've been trying to get the sum of all May YTD and May YTG amounts (to put in Table 2) for each store by using SUMPRODUCT but i keep getting #N/As. The formula I came up with is (for example, i want to get the figure for Store A)...

I attempted to modify the below formula to encompass more than the 13 rows (See original formula below): Originally Posted by Eric W H4: Code: =SUMPRODUCT(--(MATCH(B2:B13,B2:B13,0)=ROW(B2:B13)-ROW(B2)+1),--(COUNTIFS(B2:B13,B2:B13,C2:C13,"DA")=1),--(COUNTIFS(B2:B13,B2:B13,C2:C13,"THER...

Hello, I am using excel 2003 and would like to know if the below formula has any issues with it because I keep getting the #Value ! error and I'm not sure why. Below is my formula. I want the first two to be OR which is why there is a + sign between the. and the others are all * for AND...

Good morning, Looking for a little bit of help on a sum product I have messing with my head! What i have is a mass expanse of data, 4380 lines long A-AZ wide, I need my Sumproduct to look over 3 conditions, Type, Wash and then week. Each cell will show me the total monies for that week, in...