Quote:
Originally Posted by Dreganomics
I am using SUMIF in the worksheeet attached. The SumIF is being used in the Budget Breakdown tab in cell B3. As far as I know I am using the formula correctly, especially since it is working in a very similar use in cell J195 of the Projects tab. Any help as to why this formula is not acting up would be appreciated.
|
The cell you're referencing in the middle of the formula (I195) is a blank cell on the "Budget Breakdown" worksheet.
I presume you need to change that to whatever your condition is to fit your needs.
i.e. =SUMIF(Projects!I5:I46,"N",Projects!O5:Q45)
or =SUMIF(Projects!I5:I46,Projects!I195,Projects!O5:Q 45)
depending on what it is you're actually trying to do.