COUNTIF problem using a drop-down selection

**macrorookie** · 07-16-2014, 11:14 PM

Good evening,

I've been pulling my limited hair out trying to get a formula to work -- a formula that I thought would be easy. It's a COUNTIF formula that will not work for me. I attached a sample workbook with explanations about my formula goals, the actual formula that isn't working, and what the outcome should be (if the formula worked). There are three sheets in the workbook, with super-simple date.

My primary challenge is the drop-down box. I included all of the US states in the list, plus an "All" option. The "All" option seems to be tripping me up, given my other criteria (which I label in the attached sample).

I appreciate any help!

**FDibbins** · 07-16-2014, 11:30 PM

COUNTIFS() does not work with OR(), but you were pretty close. Try this....
=IF($B$6="All",COUNTIFS(Data!F:F,">="&$B$3,Data!F:F,"<="&$B$4),COUNTIFS(Data!F:F,">="&$B$3,Data!F:F,"<="&$B$4,Data!J:J,B6))

This will also work (and is shorter)...
=COUNTIFS(Data!F:F,">="&$B$3,Data!F:F,"<="&$B$4,Data!J:J,IF(B6="All","<>",B6))

**Vikas_Gautam** · 07-17-2014, 02:12 AM

Got the solution.. bro..

Check the attachment...

Don't forget, Click *

**FDibbins** · 07-17-2014, 11:10 AM

Happy to help and thanks for the feedback

COUNTIF problem using a drop-down selection

LinkBack

Thread Tools

Rate This Thread

Display

COUNTIF problem using a drop-down selection

Re: COUNTIF problem using a drop-down selection

Re: COUNTIF problem using a drop-down selection

Re: COUNTIF problem using a drop-down selection

Thread Information

Users Browsing this Thread

Similar Threads

Excel COUNTIF with Drop-down Selection

VBA Web page issue: After inputting drop down menu selection cannot submit selection

Displaying Input box based on user selection of a drop down selection

Autolock Cells from a Drop Down List Selection and a Calendar Selection

Auto-update initial drop-down selection based on previous drop-downs

Bookmarks

Bookmarks

Posting Permissions