SUMIF with text criteria not working

[vrart1]

Windows 7
Microsoft Office 2010

I have the following formula that is not working:
=SUMIF(LEDGER!H:H,BILLS,LEDGER!B:F)

The formula is being used in a sheet titled "BUDGET" to get information from another sheet within the same document titled "LEDGER". I want it to searched through the H column in order to find the text "BILLS" and then add the accompanying amount within columns B through F.

Anyone got any fixes?

 

[AhoyNC]

You need to have quotes around a text string.

=SUMIF(LEDGER!H:H,"BILLS",LEDGER!B:F)

 

[vrart1]

Still no results changed unfortunately.

 

[vrart1]

It seems to not be updating when I input new amounts.

 

[JoeMo]

It seems to not be updating when I input new amounts.

Is your calculation set to manual?
Formulas>Calculation Options>Automatic

 

[vrart1]

Is your calculation set to manual?
Formulas>Calculation Options>Automatic

It is set to automatic.

 

[AhoyNC]

Does this return a value?

=SUMPRODUCT(--(LEDGER!H:H="BILLS")*LEDGER!B:F)

 

[JoeMo]

It is set to automatic.

Just looked at your formula. The sum range will be limited to col B.

From Excel Help:
The sum_range argument does not have to be the same size and shape as the range argument. The actual cells that are added are determined by using the upper leftmost cell in the sum_range argument as the beginning cell, and then including cells that correspond in size and shape to the range argument.

If you change a value in col B, does the formula cell change?

 

[vrart1]

Just looked at your formula. The sum range will be limited to col B.

From Excel Help:
The sum_range argument does not have to be the same size and shape as the range argument. The actual cells that are added are determined by using the upper leftmost cell in the sum_range argument as the beginning cell, and then including cells that correspond in size and shape to the range argument.

If you change a value in col B, does the formula cell change?

It did change. So what changes would I have to make to the formula in order for it to incorporate the rest of the columns I require?

 

[AhoyNC]

Did you try the formula I posted above? Post #7