Adding drop downs to two dates

[uul]

Hi,

I am trying to add two dropdowns to the attached spreadsheet, so when i select any TWO dates , another box will automatically sum the column to the right with the figures between the two dates... I know this must be some sort of offset function, but i cannot get it to work. I have attached the ss that i am using. In total i am looking for four boxes two to add the date fields, and the next two to show the sum of them date ranges on the two colums of data i.e attack/pass.

Any input would be gratefully recieved.

Thanks everyone

 

[Bhawani]

So you want number of attacks & defence in lying between two days including both dates. is it you want? pls confirm

Or have a look on attached if it meets your requirement.

 

[Somendra Misra]

Hi,

Try for attack:
=SUMPRODUCT(($B$3:$B$50>=I7)*($B$3:$B$50<=J7)*$C$3:$C$50)

For defense:
=SUMPRODUCT(($B$3:$B$50>=I7)*($B$3:$B$50<=J7)*$D$3:$D$50)

Regards,

 

[Bhawani]

try this attached with function sumifs & countifs

 

[uul]

Thanks for the replies and sorry i was late getting back to you all. That is perfect