# Simplifying a big formula

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. ## 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.``

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

#### 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