# COUNTIFS multiple criteria (date range & text)

1. ## COUNTIFS multiple criteria (date range & text)

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,

2. ## Re: COUNTIFS multiple criteria (date range & text)

``Please Login or Register  to view this content.``
Cheers,

3. ## Re: COUNTIFS multiple criteria (date range & text)

You are amazing! Thank you so much. Worked perfect...

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1