I have a home-made budget I created in Excel. The last page is a project page where I have preset project numbers I can assign to allocate portions of each month's budget toward. I have a SUMIF equation which basically says if the "Project #" shows in the "Description" column on the Month work sheet, then put the sum from the "Amount" column in the in the "Applied" column on the Projects sheet.
When I use the formula for a sing sheet, i.e. "=SUMIF(February!H26:J106,"VK09001",February!C26:C106)" it calculates perfectly, however, when I use a range of sheets, i.e. "=SUMIF(January
ecember!H26:J106,"VK09001",Januaryecember!C26:C106)" I get the #VALUE!" Error. What is going on? I tested it by using just one sheet, instead of a range of sheets, for each single sheet (i.e. January, February, March, etc. etc.) and it worked every time, so I don't think there is a problem with any single cell in the formula.
Can someone help me, please?!
When I use the formula for a sing sheet, i.e. "=SUMIF(February!H26:J106,"VK09001",February!C26:C106)" it calculates perfectly, however, when I use a range of sheets, i.e. "=SUMIF(January
ecember!H26:J106,"VK09001",Januaryecember!C26:C106)" I get the #VALUE!" Error. What is going on? I tested it by using just one sheet, instead of a range of sheets, for each single sheet (i.e. January, February, March, etc. etc.) and it worked every time, so I don't think there is a problem with any single cell in the formula. Can someone help me, please?!