Forum Discussion
Compare Columns of Dates In A Formula
x
12 Replies
Hi Comp.
Your formula adds the amounts from a column (ex. AB) in the other tabs that meet your formulas criteria. If you create another column that will input the amounts from AB only if they are greater than or equal to a given date, then your sumif will only add amounts that are greater than that date.
On the other tabs you can set up a column that you can hide. Based on the date you are using, the formula will either resolve to blank, or the amount in cell ABx. IF(ab13>=TODAY(),AB13,""). TODAY() can be any date you specify, or even point to a date in another cell. You can write the formula once then drag it down. Better?
I understand the idea and started implementing that into my worksheet. The formula I wrote in a Date (Hidden) column is
=IF([@[ Date (Buy)]]="","",IF('Buying Checklist'!E28>[@[ Date (Buy)]],"",[@[ Date (Buy)]]))
Then I would have an IF before the SUMIF check for a value in these columns. However, how would I account for transactions not placed in the Buying Checklist. By doing this everything I ever purchased would also have to be put into the buying checklist. My goal is to be able to delete information from the checklist after it is entirely completed.
The values for the original total amounts are still there in the original range. (AB). You can use the total sum in AB and use the qualified sum in the new range where needed. Simple math will also give you the difference. Aside from this, I will need a better understanding. My original goal was to help you to sum your range with only the dates that met the criteria.
Hi Comp, here is an idea. Since you hide the date, use a formula that will put the amounts you are looking to sum based on >= to that date, then use those cells in your sumif formulas.
