I have a worksheet in a workbook where I need to get a sum from a range of
cells from another worksheet in the same workbook. However, I only want to
sum the values in that range if two different sets of criteria are met on
each row. Example: Worksheet1 cell B5 needs the formula. I want it to sum
all values from worksheet2 column D, only if the cells in column B and column
C on any given row (on worksheet2) match the values in worksheet1 cells A1
and B3 respectively. So for cell D3 to be counted in the sum B3(worksheet2)
must = A1(worksheet1) AND C3(worksheet2) must = B3(worksheet1). As far as I
can tell the SumIf function will only allow you to use one criteria, is there
a way around this?