Excel Formula Help!!!!

[overrated]

Hey I am stuck need help with an excel formala.

Basically here is the breakdown of what I need.

I need a formula that checks to see if there is a date in one column and checks each row if there is a date in that column and row it adds a the value in another column that matches the row the date value is.

It may sound confusing so here is an example.

So say column N has a heading of Date inserted. In that column there will be Dates but the dates are only entered when the job was inserted. In column F the heading is STMTS and has numbers in this column. So basically what I want is if there is a date in column N Row 3 for example I want it to Sum Column F Row 3. And there are multiple values as well so it could be Column N Row 3,4,5,6,7,8 has a date in it I want it to sum Column F Row 3,4,5,6,7,8.

Could someone please help me with this ASAP.

Thanks!

 

[Jonmo1]

Welcome to the board...

look at the SUMIF Function...

Are you wanting to sum column F if there is ANY date in column N ? Or a specific date ?

For ANY date in column N, AND assuming the cell will be BLANK if there is no date...


=SUMIF(N:N,">0",F:F)

or for specific date...

=SUMIF(N:N,"07/17/2007",F:F)

 

[overrated]

Thank you so much the first formula worked I didn't need a specific date.