My formula =SUMPRODUCT(SUMIF(INDIRECT(&tabs&!E18:E190″),$H8,INDIRECT(&tabs&!g18:g190″)))
Works brilliantly for me but i need to amend slightly so that the formula counts the number of items in G18:G190 rather than sums them up. Replacing SUMIF with COUNTIF unfortunately doesnt work.
Also I need to amend the formula after that to count the number of items that are in I18:I190 (instead of G18:G190) that have the word Bound in it.
Any thoughts?
Bookmarks