Need help for Count value with condition

[wlinksanju]

Here in attachment i need a help on Count a value with three different condition As below

count "A" column if column "B" date is less then column "C" date
Count "A" column if the date at column "B" is within 6 days from column "C" date
Count "A" column if the date at column "B" is above 6 days from Column "C" date

[FDibbins]

I dont have time to spend on this right now, but take a look at using =COUNTIFS()

[wlinksanju]

tried but unable to input condition with dates

[Glenn Kennedy]

Maybe..

G2:
=SUMPRODUCT(($A$2:$A$7=$F2)*($B$2:$B$7<$C$2:$C$7))

H2:
=SUMPRODUCT(($A$2:$A$7=$F2)*($B$2:$B$7<=$C$2:$C$7+6))-$G2

I2:
=SUMPRODUCT(($A$2:$A$7=$F2)*($B$2:$B$7>$C$2:$C$7+6))

[wlinksanju]

Thankyou very much