If & Then

  • Thread starter Thread starter Yo
  • Start date Start date
Y

Yo

Maybe someone can help me...........

In column B I have dates.
In column G I have total due.

On summary box at top of page (G2) I want to have the total due today show.

What I need is: IF B(any) = Todays Date, then G (same row)

But I don't know what formula to use. Can this even be done?

Thanks,

Yosemite
 
Yosemite,

Put this formula in cell G2:

=SUMIF(A5:A10,TODAY(),G5:G10)

This is assuming you have a range that starts in A5 and ends in A10.
You will need to adjust your range accordingly.

-Chris
 
Back
Top