I'm trying to do a Sumifs to find the sum of cells in a column that match criteria in two other columns (same row). I'm getting a Value error. I need to use the criteria that links the current cell in that row (so if Im in row 5, one criteria should be "=D3".

Can I not use cell references as criteria? Do the cell references have to be in a certain format?? Any help would be great!