Forum Discussion
SUMIFS AUTOMATING THE CRITERIA
I wanted to see why you have to reference the criteria exactly in a sun ifs formula or if there is a work around it? I would like to be able to drag and drop this formula to automatically use new cri...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Actually disregard, I think I was just trying to keep the parentheses before and after putting the cell in the criteria and that is why it was not working