Help with a sumif formula
Hi I am looking to make a budget spreadsheet that lets me see when money has been spent but is also committed. I have managed to get a Sumif column to work out if money has been allocated within a certain time but I would like it to do more if possible. I cannot seem to get a formula that works so any advice would be welcome. Basically, I want it to do two things in the committed spend box: 1- check if the money has been committed within the year e.g. 1/04/19 -31/03/20, 2- then check if it has been paid out by looking at the paid column.
Help with Cash-flow schedule
Hello, I am building a worksheet in which using contract details, I can have a calendar that displays each day's deposits. I need help with my formula that is not displaying the result requested. To best describe my issue, here is a picture of my worksheet: The columns from B to F are input column where I write the information of the contract. The column H to J are calculated using basic formulas. There seems to be 1 main issue with my formula. For the first month, from cell M3 until M35, the result is correct but from M36 on, it doesn't display any of the contract planned deposits. any idea what is wrong and how to fix it? I have attached my excel file as a reference. Your help is greatly appreciated. here is the solution: https://www.excelforum.com/excel-formulas-and-functions/1263565-cash-flow-planning-per-day.html#post5061110Sumif formula need help
2/9/18 10.38 3371 EL POLLO LOCO LOS ANGELS CA 2/17/18 16.18 3372 EL POLLO LOCO LOS ANGELS CA 1/1/18 45 705 FASTRIP #641 LOS ANGELES CA 1/1/18 51 706 FASTRIP #641 LOS ANGELES CA 2/5/18 52.97 707 FASTRIP #641 LOS ANGELES CA trying to categorize expenses, thinking I could use sumif to look at a column and sum all the expenses for El Pollo, Fastrip, etc., but it doesn't seem to work. Is there another formula I could use. Thanks.
Referencing across sheets using row numbers
Dear All, Sheet 1 summarises Values listed in Sheet 2. Sheet 1 has categories listed in Column A , and a formula in Column B Sheet 2 contains a list of expenses that I want add up in Sheet 1, by using the Row numbers in Sheet 1 as a reference, rather than use the names of the categories. So Sheet 2 has numbers to represent rows in sheet 1 listed in Column A , and the amounts in Column B, ie 8 $500 The formula in Sheet 1 , Column B will be something like : =SUMIF(Sheet2!A2:A1000,"Sheet1!ROW()",(Sheet2!B2:B1000)) So that in Sheet 1, Row 8, it would summarise all values from Sheet 2 that have an 8 in the reference column. But it's not working. Should I use and INDIRECT in there ? Any suggestions would be much appreciated - I tried without the Sheet1! in front of ROW(), I also tried to fixate the row numbers in Sheet 1 in a column so that it could take it from there, but that's not working either. I hope you don't think I am complicating my life unnecessarily - Thanks, BenReferencing across sheets using row numbers
Dear All, Sheet 1 summarises Values listed in Sheet 2. Sheet 1 has categories listed in Column A , and a formula in Column B Sheet 2 contains a list of expenses that I want add up in Sheet 1, by using the Row numbers in Sheet 1 as a reference, rather than use the names of the categories. So Sheet 2 has numbers to represent rows in sheet 1 listed in Column A , and the amounts in Column B, ie 8 $500 The formula in Sheet 1 , Column B will be something like : =SUMIF(Sheet2!A2:A1000,"Sheet1!ROW()",(Sheet2!B2:B1000)) So that in Sheet 1, Row 8, it would summarise all values from Sheet 2 that have an 8 in the reference column. But it's not working. Should I use and INDIRECT in there ? Any suggestions would be much appreciated - I tried without the Sheet1! in front of ROW(), I also tried to fixate the row numbers in Sheet 1 in a column so that it could take it from there, but that's not working either. I hope you don't think I am complicating my life unnecessarily - Thanks, Ben
SUMIF Formula populating wrong data
My SUMIF Formula works in my entire workbook except there are certain cells where it's pulling the wrong data. Attached is a sample subset. I've tried ensuring the cells are in the same format, etc. I use SUMIF extensively so I'm not sure what the issue is. Any thoughts?
SUMIF with multiple conditions
I'm trying to create a formula that will add together a list of numbers in a column (B) based on the value of another column(A), however I also want to add a condition to divide the number by 2 before it calculates the total if "/" is present in column A. Hope this makes sense, thanks in advance!!
