Oups. The formulae are :
=SUM(IF(MATCH(A7,$A$7:$A$12,0)=MATCH($A$1:$A$4,$A $7:$A$12,0),1,0)*IF(MATCH(A7,$A$7:$A$12,0)<=MATCH( $B$1:$B$4,$A$7:$A$12,0),1,0)*$C$1:$C$4)
and
=SUM(IF(MATCH(A7,$A$7:$A$12,0)=MATCH($A$1:$A$4,$A $7:$A$12,0),1,0)*IF(MATCH(A7,$A$7:$A$12,0)<=MATCH( $B$1:$B$4,$A$7:$A$12,0),1,0)*$D$1:$D$4)
Daniel


Sorry, I put my data on row 7 instead of 19; Here is an example :
http://www.filedropper.com/jeremy
Daniel

I must be doing something wrong because I can't seem to get this to pull
anything. Why is there are reference to A7 and a7 has nothing in it?

Thank you

"Daniel.C" wrote:

For C19, try the following array formula :
(validate with Ctrl+Shift+Enter)
=SUM(IF(MATCH(A7,$A$7:$A$12,0)=MATCH($A$1:$A$4,$A $7:$A$12,0),1,0)*IF(MATCH(A7,$A$7:$A$12,0)<=MATCH( $B$1:$B$4,$A$7:$A$12,0),1,0)*$C$1:$C$4)
For D19 :
=SOMME(SI(EQUIV(A7;$A$7:$A$12;0)=EQUIV($A$1:$A$4; $A$7:$A$12;0);1;0)*SI(EQUIV(A7;$A$7:$A$12;0)<=EQUI V($B$1:$B$4;$A$7:$A$12;0);1;0)*$D$1:$D$4)
Drag down as needed.
HTH
Daniel


I am looking for a way to formulate the data in C19-24 as well as D19-24
using the information in A,B,C and D 1-4. Please note it is counting the
data including the months given and the months between. Can someone
please help with a formula.

Thank you


A B C D
1 JAN JUNE 2 4 2 MAR JUNE 1
16
3 MAR MAR 2 2
4 FEB MAR 3 4

A B C D
19 JAN 2 4
20 FEB 5 8
21 MAR 8 26
22 APRIL 3 20
23 MAY 3 20
24 JUNE 3 20