sumproduct value between two days

[padmanabham]

Hi all,

Sheet 1
[TABLE="width: 895"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Sl No[/TD]
[TD]Date Deducton[/TD]
[TD]Assessment Year[/TD]
[TD]Section[/TD]
[TD]Deductee Type[/TD]
[TD]Amount[/TD]
[TD]Rate of Interest[/TD]
[TD]TDS[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]01-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194C[/TD]
[TD]Company Deductee[/TD]
[TD] 58,022[/TD]
[TD]2%[/TD]
[TD] 1,160[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]04-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194C[/TD]
[TD]Company Deductee[/TD]
[TD] 11,000[/TD]
[TD]2%[/TD]
[TD] 220[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]04-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194C[/TD]
[TD]Company Deductee[/TD]
[TD] 3,443[/TD]
[TD]2%[/TD]
[TD] 69[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]01-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Company Deductee[/TD]
[TD] 500,000[/TD]
[TD]10%[/TD]
[TD] 50,000[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]01-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Non Company Deductee[/TD]
[TD] 40,000[/TD]
[TD]10%[/TD]
[TD] 4,000[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]01-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Non Company Deductee[/TD]
[TD] 110,000[/TD]
[TD]10%[/TD]
[TD] 11,000[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]01-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Company Deductee[/TD]
[TD] 25,000[/TD]
[TD]10%[/TD]
[TD] 2,500[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]01-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Company Deductee[/TD]
[TD] 25,000[/TD]
[TD]10%[/TD]
[TD] 2,500[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]01-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Non Company Deductee[/TD]
[TD] 71,252[/TD]
[TD]10%[/TD]
[TD] 7,125[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]01-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Company Deductee[/TD]
[TD] 28,600[/TD]
[TD]10%[/TD]
[TD] 2,860[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]01-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Non Company Deductee[/TD]
[TD] 5,000[/TD]
[TD]10%[/TD]
[TD] 500[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]05-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Company Deductee[/TD]
[TD] 223,000[/TD]
[TD]10%[/TD]
[TD] 22,300[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]31-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Company Deductee[/TD]
[TD] 25,000[/TD]
[TD]10%[/TD]
[TD] 2,500[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]31-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Company Deductee[/TD]
[TD] 25,000[/TD]
[TD]10%[/TD]
[TD] 2,500[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]31-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Non Company Deductee[/TD]
[TD] 40,000[/TD]
[TD]10%[/TD]
[TD] 4,000[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]31-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Non Company Deductee[/TD]
[TD] 110,000[/TD]
[TD]10%[/TD]
[TD] 11,000[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]31-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Company Deductee[/TD]
[TD] 28,600[/TD]
[TD]10%[/TD]
[TD] 2,860[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]31-12-14[/TD]
[TD]AY 2015-16[/TD]
[TD]194J[/TD]
[TD]Non Company Deductee[/TD]
[TD] 5,000[/TD]
[TD]10%[/TD]
[TD] 500[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]01-01-15
[/TD]
[TD]AY 2015-16
[/TD]
[TD]194J[/TD]
[TD]Non Company Deductee[/TD]
[TD] 2,527,000[/TD]
[TD]10%[/TD]
[TD] 252,700[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]02-01-15
[/TD]
[TD]AY 2015-16
[/TD]
[TD]194J[/TD]
[TD]Non Company Deductee[/TD]
[TD] 71,252[/TD]
[TD]10%[/TD]
[TD] 7,125[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD="align: right"]01-01-15
[/TD]
[TD]AY 2015-16
[/TD]
[TD]194I[/TD]
[TD]Company Deductee[/TD]
[TD] 168,500[/TD]
[TD]10%[/TD]
[TD] 16,850[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]03-01-15
[/TD]
[TD]AY 2015-16[/TD]
[TD]192B[/TD]
[TD]Non Company Deductee[/TD]
[TD] 374,669[/TD]
[TD]Payroll[/TD]
[TD] 374,669[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 1
[TABLE="width: 763"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]01/12/2014[/TD]
[TD]31/12/2014[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Nature[/TD]
[TD]Deductee Type
[/TD]
[TD]Type of Payment[/TD]
[TD]Section[/TD]
[TD]A.Y[/TD]
[TD]Tax[/TD]
[/TR]
[TR]
[TD]Rent [/TD]
[TD]Non Company Deductee[/TD]
[TD]200 TDS/TCS Payable by Tax payer[/TD]
[TD]194I[/TD]
[TD]2015-2016[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]Rent [/TD]
[TD]Company Deductee[/TD]
[TD]200 TDS/TCS Payable by Tax payer[/TD]
[TD]194I[/TD]
[TD]2015-2016[/TD]
[TD] 16,850[/TD]
[/TR]
[TR]
[TD]Professionals[/TD]
[TD]Non Company Deductee[/TD]
[TD]200 TDS/TCS Payable by Tax payer[/TD]
[TD]194J[/TD]
[TD]2015-2016[/TD]
[TD] 297,950[/TD]
[/TR]
[TR]
[TD]Professionals[/TD]
[TD]Company Deductee[/TD]
[TD]200 TDS/TCS Payable by Tax payer[/TD]
[TD]194J[/TD]
[TD]2015-2016[/TD]
[TD] 88,020[/TD]
[/TR]
[TR]
[TD]Contractors[/TD]
[TD]Company Deductee[/TD]
[TD]200 TDS/TCS Payable by Tax payer[/TD]
[TD]194C[/TD]
[TD]2015-2016[/TD]
[TD] 1,449[/TD]
[/TR]
[TR]
[TD]Contractors[/TD]
[TD]Non Company Deductee[/TD]
[TD]200 TDS/TCS Payable by Tax payer[/TD]
[TD]194C[/TD]
[TD]2015-2016[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]Salaries [/TD]
[TD]Non Company Deductee[/TD]
[TD]200 TDS/TCS Payable by Tax payer[/TD]
[TD]192B[/TD]
[TD]2015-2016[/TD]
[TD] 374,669[/TD]
[/TR]
[TR]
[TD]Foreign Payments[/TD]
[TD]Company Deductee[/TD]
[TD]200 TDS/TCS Payable by Tax payer[/TD]
[TD]195[/TD]
[TD]2015-2016[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]i have put insert the formula =SUMPRODUCT(('TDS Details'!$E$3:$E$40=D6)*('TDS Details'!$F$3:$F$40=B6),'TDS Details'!$I$3:$I$40)

With the above formula i need details between 01st Dec 14(A1) to 31st Dec 14(B1) only.

Thanks in advance
[/TD]
[TD] [/TD]
[TD]
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[onlyadrafter]

Hello,

does this give required answers?

=SUMPRODUCT(('TDS Details'!$E$3:$E$40=D6)*('TDS Details'!$F$3:$F$40=B6)*('TDS Details'!$C$3:$C$40>=$A$1)*('TDS Details'!$C$3:$C$40<=$B$1),'TDS Details'!$I$3:$I$40)

 

[padmanabham]

Hello,

does this give required answers?

=SUMPRODUCT(('TDS Details'!$E$3:$E$40=D6)*('TDS Details'!$F$3:$F$40=B6)*('TDS Details'!$C$3:$C$40>=$A$1)*('TDS Details'!$C$3:$C$40<=$B$1),'TDS Details'!$I$3:$I$40)

Perfect,thank you