I have created dynamic named ranges using cell reference and index formula. e.g. $a$1:index($a$1:$A$300,counta($a$1:$A$300))
I used those dynamic named ranges in sumifs and sumproduct (because in sumifs it didnt work, I tried sumproduct also) like
=SUMIFS(ORDERS,PRODUCTS,PRODUCT1,DATES,">="&DATE1,DATES,"<"&DATE2)
ORDERS, PRODUCTS and DATES are dynamic named ranges, product1, date1 and date2 are respective criteria in cells.
it gave me value error.
same with sumproduct structure also.
Although I managed the thing without DNRs, but still if someone enlighten me if this will happen with DNR and SUMIFS/SUMPRODUCT ?????![Roll eyes :rolleyes: :rolleyes:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I used those dynamic named ranges in sumifs and sumproduct (because in sumifs it didnt work, I tried sumproduct also) like
=SUMIFS(ORDERS,PRODUCTS,PRODUCT1,DATES,">="&DATE1,DATES,"<"&DATE2)
ORDERS, PRODUCTS and DATES are dynamic named ranges, product1, date1 and date2 are respective criteria in cells.
it gave me value error.
same with sumproduct structure also.
Although I managed the thing without DNRs, but still if someone enlighten me if this will happen with DNR and SUMIFS/SUMPRODUCT ?????