Results 1 to 9 of 9

IF AND Statement Not Working When Logical Test is Data Validation

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2019
    Location
    Orange Park, FL
    MS-Off Ver
    2016
    Posts
    3

    IF AND Statement Not Working When Logical Test is Data Validation

    Attached is my spreadsheet.

    I have a Data Validation List in the M Column that you can select what kind of tax the order is. I need my formula to look at the date and if it equals 9 then check to see if the list equals "Out_of_State". If both are true, I need it to SUM the Taxable Amount.

    I've tried =IF(AND(MONTH(Etsy!$A$2:$A$3000=9), Etsy!$M$2:$M$3000="Out_of_State"),SUM(Etsy!$J$4:$J$3000),0)

    But it just returns 0.

    Any ideas would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF statement with IF Statement as logical test, and output if false
    By wetbean in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2018, 12:59 PM
  2. [SOLVED] If/then statement with variable in logical test and value fields
    By kahayler in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-15-2017, 01:02 PM
  3. If statement logical test range cells
    By rhudgins in forum Excel General
    Replies: 4
    Last Post: 12-07-2010, 04:51 PM
  4. logical test not working
    By arora in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2008, 05:08 AM
  5. Second Logical test in if statement
    By speakers_86 in forum Excel General
    Replies: 3
    Last Post: 12-18-2007, 03:21 PM
  6. [SOLVED] If statement where the logical test is a range that equals a word
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 12:05 PM
  7. [SOLVED] If statement where the logical test is a range that equals a word
    By Steve o in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Bookmarks

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