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?
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?