Contract End Date | amounts | |
<tbody> </tbody> | 50 | |
2/5/14 | 60 | |
4/6/14 | 70 |
<tbody>
</tbody>
Hello - I'm trying a sumif (I think) where I need to sum the "amounts" column if the contract end date is within a certain number of months from a beginning date. For example, how would I sum the "amounts" column if I wanted all contracts that started within 2 months of Jan. 1 2014? It should sum the 50+60 since they are in the range but not 4/6/14 since it is out of the 2 months window.
Thanks very much