Attached it comes a picture, and if you open it, you can read my issue explained in a more easy way to understand
http://www.excelforum.com/attachment...1&d=1476193061
Summarizing in words, i have a range of cells with in column A and C criteria (product type and group name) and in column D,E,... the values that i want to sum whenever product and group are the ones indicated
I want the sum to be a row of the table, a kind of subtotal, and i know that the table can be sorted therefore each row can change relative position
I can use sumif on the whole table specifying as sum_range only column D, however i am unable to avoid sumif to consider its own cell in the table range, therefore i get the message of circular reference
Maybe mixing together array, indirect, vlookup and sumif functions, it is possible. Can someone find the solution?
The sample file is also attached: http://www.excelforum.com/attachment...1&d=1476193061
Many thanks!
Paolo
Bookmarks