+ Reply to Thread
Results 1 to 2 of 2

IF - AND not working properly?

  1. #1
    Registered User
    Join Date
    12-29-2019
    Location
    Ohio
    MS-Off Ver
    Office 365
    Posts
    1

    IF - AND not working properly?

    Hello all, I am new to the forums. I feel like I know a bit about Excel, but certainly not *that* intelligent.

    I'm attempting to create a spreadsheet that will compile cash register data for me automatically from data that I export from a different program. The exporting issue isn't my problem; I just can't seem to get my "IF AND" formula to work the way I want.

    What I have are two worksheets within a single book. The first sheet is called "December Totals" - this is the data that is exported from an external program. I have the numerical data all formatted to the correct category (date, number, etc.).

    DecTotals.JPG

    The second sheet is called "December Final" - this is the workbook I will print out from the compiled data.

    DecFinal.JPG

    As you can see, on the "Totals" sheet, there are numerous dates showing cash taken in on certain registers; not all registers have cash transactions each day, so there is no data to export. I'd like to get the "Total Discrepancy" column data to be input into the correct cell, depending on the date and register that had the discrepancy. However, my current formula is not working:

    =IF(AND('December Final'!B3='December Totals'!B:B, 'December Final'!C2='December Totals'!A:A), 'December Totals'!H:H, "")

    I've tried selecting the entire column (B:B) and individual cells excluding the headers (B2:B17) to no avail.

    Hopefully I've explained my issue well enough. I'm turning to the geniuses on this forum to slap me across the face with my error and hopefully get me pointed in the right direction!

    Thank you all in advance!!

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,055

    Re: IF - AND not working properly?

    Hello and Welcome to the Forum,

    Give this a try...

    C3 copied across and down >> =SUMIFS('December Totals'!$H:$H,'December Totals'!$A:$A,C$2,'December Totals'!$B:$B,$B3)

    If this does not do it, how about attaching a sample workbook. Without a sample workbook we have to redo your work. (See the "Yellow" banner about)
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. countif not working properly
    By Patcheen in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-18-2018, 06:44 PM
  2. [SOLVED] Array not working properly
    By Mvaldesi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-29-2017, 12:31 PM
  3. [SOLVED] More than and Less than not working properly
    By Alidamalang110 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-23-2015, 12:34 PM
  4. COUNTIFS not working properly
    By MavGunloc in forum Excel General
    Replies: 4
    Last Post: 12-17-2014, 12:31 PM
  5. [SOLVED] IF-THEN-ELSE not working properly
    By danex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-02-2013, 11:15 AM
  6. VBA not working properly
    By stevemills04 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2013, 02:56 PM
  7. UDF not working properly
    By demuro1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2008, 04:36 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