For some reason I cannot attach my sheet, but here is what im having issues with
=SUMIF(Ledger!B:B,(AND("Cash",Ledger!A:A<=E4)),Ledger!D:D)
I want this function to SUM IF On the sheet "Ledger" column B is "Cash" and Column A(The date) is less than E4 which is the date on the primary sheet. If both of these conditions are met, sum the values in column D on the ledger.
Primary sheet picture: https://gyazo.com/4bd99301a453cbcd87352b98b779e11f
Ledger picture: https://gyazo.com/459561ac3851ab690281543c82cb1612
To clarify, I want to use SUMIF to add the values from the ledger if they are "Cash" and Before the date of 1/29/16 (E4).
Thanks for your help.
Bookmarks