date comparison and formatting

[jimfout1964]

I am trying to compare dates in one column to today's date. If the date is within 3 days of today I would like to count and total it at the bottom of the column.

[#2]

@jimfout1964 

Hello,

Below formula should work.

SUMIF(DATERANGE;">="&TODAY()-3;SUMRANGE)

[#3]

@erol sinan zorlu 

Would i put this formula in the place where I want the total?

[#4]

@jimfout1964 

yes exactly.

[#5]

@erol sinan zorlu 

Not working, I think I am missing something. the formula is correct but there is no calculation.

[#6]

@jimfout1964 

please check the attached file.