Problem with Formula

[RLJ]

I am having trouble getting the order correct for this formula

=Sumif($C$5:$C$105,TODAY($H$5:$H$105))

 

[gehusi]

SUMIF requires three inputs - a range, a criteria applied to the range, and the corresponding range you'd like to sum.

 

[Scott Huish]

Does this do what you want? If not, please explain what it is you are trying to accomplish.

=SUMIF(H5:H105,TODAY(),C5:C105)