SUMIF returning incorrect answer

[Dreganomics]

I am using SUMIF in the worksheeet attached. The SumIF is being used i
the Budget Breakdown tab in cell B3. As far as I know I am using th
formula correctly, especially since it is working in a very similar us
in cell J195 of the Projects tab. Any help as to why this formula is no
acting up would be appreciated

+-------------------------------------------------------------------
|Filename: HelpWB.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=518
+-------------------------------------------------------------------

 

[Ron Rosenfeld]

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.


+-------------------------------------------------------------------+
|Filename: HelpWB.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=518|
+-------------------------------------------------------------------+

Well, for one thing, cell I195, your criteria cell, is blank. Probably you mean for your criteria to be Projects!I195

Also, I note that the "range" and the "sum_range" in that formula are of different sizes. Although that is sometimes desired, it may be a typo in your formula.

 

[Spencer101]

I am using SUMIF in the worksheeet attached. The SumIF is being used i
the Budget Breakdown tab in cell B3. As far as I know I am using th
formula correctly, especially since it is working in a very similar us
in cell J195 of the Projects tab. Any help as to why this formula is no
acting up would be appreciated.

The cell you're referencing in the middle of the formula (I195) is
blank cell on the "Budget Breakdown" worksheet.

I presume you need to change that to whatever your condition is to fi
your needs.

i.e. =SUMIF(Projects!I5:I46,"N",Projects!O5:Q45)
or =SUMIF(Projects!I5:I46,Projects!I195,Projects!O5:Q45)

depending on what it is you're actually trying to do

+-------------------------------------------------------------------
+-------------------------------------------------------------------