# Help with formula

#### asalman07

##### Active Member
 Thanks in advance for your help on this. I am trying to create a formula to get total revenue by multiplying Days times the Average daily revenue. as you can see the 100 is the 20 days times the 5 for ADR. The problem i run into is when i copy the formula down to FUEL. The formula picks up ATA and not FUEL. is there a way to solve this? Thanks again! IP 100 TD IP IPFS TD IPFS DOMESTIC FUEL

<TBODY>
</TBODY>

DAYS 20

 IP 5 TD IP IPFS TD IPFS DOMESTIC ATA PSALMS IXF CD OTHER REV W/O FUEL FUEL

<TBODY>
</TBODY>

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Anyone

Replies
0
Views
1K
Replies
13
Views
870
Replies
4
Views
207
Replies
1
Views
669
Replies
8
Views
501

1,219,574
Messages
6,149,087
Members
450,857
Latest member
Karomi

### 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.

### Which adblocker are you using?

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

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