Hi All,
I recently had the problem of using sumif function across a horizontal and vertical plane at the same time. I have used a sumproduct function to solve my difficulties and am getting the results I want. However the data size this formula is covering is large and the sumproduct function is taking up too much of my work PC processing power (have requested an upgrade - denied).
Please can you help me come up with an alternative formula that will:
a) Get the right results (sum the right cells)
b) Take less power to calculate
c) Be very easy to drag across a large number of cells
I have atached a sample data set with the formula in. I have removed the $ signs for ease but would reinsert these so the formula can be dragged around. The formula is in the highlighted cell.
Many Thanks
Bookmarks