I have written the following countif formula, but need to add a second criteria and cannot get it to work.
=COUNTIF(A1:A9, ">=1/1/2008")
I would like to have an equation that can count the number of occurances between two dates (so I can count visits per quarter). For example, 1/1/08 to3/31/08. Once I get the number of visits per quarter I will multiply it by a dollar amount. However, each visit (column) has a different dollar amount associated with it and the visit windows in each column will all be at different times during the year.
The equation above is all inclusive for anything greater than 1/1/08. Any help would be appreciated. If there is a better way to do this I am open to suggestions.
Bookmarks