If & Then

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
 
C

ccfatzin

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
 
Top