I’m using a formula in an Excel spreadsheet on Sheet1. I want to use the same formula on Sheet2. I think the formula needs the reference “Sheet1!” but when I try to add it, I get an error. I’m obviously not entering it at the correct place in the formula. The formula on sheet1 is =SUMIF(C13:C2238,”Health/Medical”,G13:G2238).
