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,