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?

 

[Marcelo Branco]

Maybe

=SUMPRODUCT((LEDGER!H2:H100="BILLS")*LEDGER!B2:F100)

Note: For performance reasons avoid references to entire columns (such as H: H for example) in SUMPRODUCT.
I assumed that your data is in rows 2:100 - adjust to suit.

M.

 

[vrart1]

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

It returns an error.

 

[AhoyNC]

What type of error? Are there only values in columns B to F or is there text mixed in?

 

[vrart1]

Maybe

=SUMPRODUCT((LEDGER!H2:H100="BILLS")*LEDGER!B2:F100)

Note: For performance reasons avoid references to entire columns (such as H: H for example) in SUMPRODUCT.
I assumed that your data is in rows 2:100 - adjust to suit.

M.

This formula worked just fine :D