Results 1 to 3 of 3

Embedding If Statement into SUMPRODUCT

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    Embedding If Statement into SUMPRODUCT

    Refer to the attached spreadsheet on the Summary Day Count tab in cell M13. I would like to add to the SUMPRODUCT formula that I have and say if the appropriate cell in the range $AI$3:$AI$20000 has a blank value then not to include it in the Total # count. Can anyone help with this asap? Thanks a lot!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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