Good morning all,
I have a simple sumproduct formula, that works against one sheet, however, i need it to also sum against multiple sheets within the same workbook using a named range. i have tried using indirect but to no avail.
can anyone help me,
thanks reg
Try this:
Make a Column C in each of Sheet 2 to Sheet 6 that concatenates columns A and B
Then use formula in Totals!B3:=SUMPRODUCT((COUNTIF(INDIRECT("'"&sheets&"'!$C$1:$C$15"),B$2&$A3)))
copied down and across
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
thanks nbvc
works great
thansk reg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks