# Excel Formula Help!!!!

#### overrated

##### New Member
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!

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### Jonmo1

##### MrExcel MVP
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

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

Replies
21
Views
642
Replies
1
Views
252
Replies
18
Views
459
Replies
3
Views
192
Replies
6
Views
180

Threads
1,190,743
Messages
5,982,699
Members
439,790
Latest member
jonaust

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back