Hello,
I need a formula that will capture data from 2 columns in my spreadsheet. One column contains the dates and the other column contains text.
Column B - Contains the text (New, Relo, Reno)
Column T - Contains dates (between the range of 2/1/2015 & 2/28/2015)
I am trying to find a formula to give me a total of all the cells that contain the word "New" between the date ranges of "2/1/2015-2/28/2015". How do I combine these 2 formulas into 1?
=Countif(B3:B42,"=New")
=Countifs(T3:T42,">2/1/2015",T3:T42,">2/28/2015")
Thank you,
Bookmarks