Sumif greater than or equal to today

[nagesh.tvsr]

Hi,

I am confused to put the formula of subtraction and sum, if the date is Greater than or equal to today.

An excel file attached with necessary details.

Pl. help.

Thanks,
Nagesh.

[dosydos]

if i am reaading this correctly the answer should be what is highlighted in yellow?
if so try this in cell C3 and drag down:

=SUM($B3-SUMIF($D$2:$O$2,">="&$B$1,$D3:$O3))

[dosydos]

another option would be to remove the today() function in cell B1 and just use this formula in C3 instead:

=SUM($B3-SUMIF($D$2:$O$2,">="&TODAY(),$D3:$O3))

[Roel Jongman]

try this.

=$B3-SUMIF($D$2:$O$2,">="&$B$1,$D3:$O3)

[nagesh.tvsr]

Yes. Its working fine. Thank you dosydos.

[nagesh.tvsr]

Thank you Roel Jongman. Yours also working fine.

[dosydos]

Glad it worked, and thanks for the feedback