Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF returning incorrect answer
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.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF returning incorrect answer
On Wed, 1 Aug 2012 22:44:27 +0000, Dreganomics .*DELETETHIS* wrote:
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. |
#3
|
|||
|
|||
Quote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=LEN returns incorrect answer | Excel Programming | |||
AutoFilter Top 10 - Incorrect Answer | Excel Discussion (Misc queries) | |||
Pmt formula returns incorrect answer | Excel Discussion (Misc queries) | |||
Formula incorrect answer | Excel Discussion (Misc queries) | |||
Sum Function sometimes displays incorrect answer | Excel Worksheet Functions |