Sum and return a values as per lookup dates in Column K to N.

[Mohammad Munawar]

Hi,

Need a formula help to return a sum values as based on data in column C to F, look up dates mentioned in cells K2 to N2 for summing values in between the dates stated.


Sample sheet are attached.


Thanks,

[Glenn Kennedy]

With a slight change of layout, to keep it simpler:

=SUMPRODUCT(($A$2:$A$31>=K$1)*($A$2:$A$31<=K$2)*$C$2:$C$31)

see sheet.

[Mohammad Munawar]

Many thanks to Mr. Glenn for your provided solution/formula help.