Sumif help...
Hi, I need help with a sumif/sumifs formula... My formula currently looks like this: =SUMIFS(AX3:AX433,BK3:BK433,">"&$CN$3,BK3:BK433,"<"&$CN$4,BV3:BV433,">"&$CN$3,BV3:BV433,"<"&$CN$4) This formula sums AX3:AX433 if both BK3:BK433 and BV3:BV433 are between the date ranges identified in CN3 and CN4. However, what I want to be able to do is sum AX3:AX433 if one or both of BK3:BK433 and BV3:BV43 are between the date ranges identified in CN3 and CN4. I also don't want to double count anything from AX3:AX433 if both BK3:BK433 and BV3:BV43 are between the date ranges identified in CN3 and CN4. It currently doesn't do that, but I just thought I should mention it. Any help would be greatly appreciated! Thanks
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#post5061110
Drag copy SUMIFS just repeats my cell values (manual entering is fine)
I am trying to drag copy (well double clicking the '+' to copy actually) the following SUMIFS functions: =SUMIFS(roadtransco15!$D$2:$D$146729,roadtransco15!$A$2:$A$146729,A2,roadtransco15!$B$2:$B$146729,B2) =SUMIFS(roadtransco15!$D$2:$D$146729,roadtransco15!$A$2:$A$146729,A3,roadtransco15!$B$2:$B$146729,B3) =SUMIFS(roadtransco15!$D$2:$D$146729,roadtransco15!$A$2:$A$146729,A4,roadtransco15!$B$2:$B$146729,B4) The function works just fine, but when I drag copy it just repeats the above 3 lines over and over. What can I do to resolve this? Many thanks!
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!!
