+ Reply to Thread
Results 1 to 2 of 2

Simplifying a big formula

  1. #1
    Registered User
    Join Date
    02-01-2012
    Location
    -
    MS-Off Ver
    Excel 2050
    Posts
    1

    Simplifying a big formula

    Hi there!
    i feel that this formula can be way more simple... can you guys help me with this?

    =SUMPRODUCT((_1=BM4)*(_FC<=CP2)*(_FC>=CP1)+(_2=BM4)*(_FC<=CP2)*(_FC>=CP1)+(_3=BM4)*(_FC<=CP2)*(_FC>=CP1)+(_4=BM4)*(_FC<=CP2)*(_FC>=CP1)+(_5=BM4)*(_FC<=CP2)*(_FC>=CP1)+(_6=BM4)*(_FC<=CP2)*(_FC>=CP1)+(_7=BM4)*(_FC<=CP2)*(_FC>=CP1))

    (_FC<=CP2)*(_FC>=CP1) = are the days of a month (january for instance)
    _1 to _7 are ranges
    BM4 is a constant

    I would greatly appreciate your help

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Simplifying a big formula

    Hi, try this.

    Please Login or Register  to view this content.
    If you want to count BM4 only one time for a row, try this

    Please Login or Register  to view this content.
    Last edited by Haseeb Avarakkan; 06-22-2012 at 10:04 PM. Reason: Typo
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ Reply to Thread

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