Forum Discussion
INDEX & MATCH with SUMIF(S)
Hi assistance requested please. I use INDEX/MATCH formula in report charts to pull Sales data for each commodity to provide weekly or monthly summaries. e.g. =INDEX(Sales!C$4:C$55,MATCH(C$6,Sales!B$...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?