Opps, use

=sumproduct(--(A1:A3="NBC"),--(D3B1:B3),--(D4<B1:B3),c1:c3)

"Eduardo" wrote:

Hi,
sorry I didn';t take in consideration NBC change to

=sumproduct(--(A4="NBC"),--(D3B1:B100),--(D4<B1:B100),c1:c100)

"Jeremy" wrote:

Could not get it to work but keep in mind A:1 to A3 might not all be NBC so I
need it to count if it matches A4 and so on.


"Eduardo" wrote:

Hi,
try

In D4 enter

=sumproduct(--(D3B1:B100),--(D4<B1:B100),c1:c100)

"Jeremy" wrote:

I am trying to write a count if formula to count the total in A1:A3 and count
it to what is in B4:7 in D on if the date in B1:B3 falls in the range of the
date given in D2 and on. Examples below

Thank you for the help



A B C
1 NBC 4/20/09 7865.42

2 NBC 3/28/09 1268.42

3 NBC 4/22/09 1000.00



A D E F
1 Week Start Week Start Week Start

2 3/30/09 4/13/09 4/27/09
4 NBC 1268.42 8865.42