If & Then

[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

 

[Bob Phillips]

=SUMIF(B3:B100,TODAY(),G3:G100)

 

[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

 

[ATK]

=SUMIF(A:A,TODAY(),B:B)