Jeff_L_123
New Member
- Joined
- Nov 9, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi Mr. Excel Question Board, I am trying to total columns and rows, each contain dual currencies (EURO and USD) in the same Column or Row. The total for EURO and total for USD can be on separate lines at the bottom of each column. Not sure how to present these separate totals for each row. What is the BEST Excel function to accomplish this? Secondly, I do not know how to use VBA or Macros. Attached please find my sample spreadsheet. Thanks for your help!! Jeff_L_123
Excel Formula:
April | Aug. | Sept. | Oct. | Nov. | Dec. | Total | |
€ 1,124,475 | |||||||
€ 1,124,473 | |||||||
€ 1,432,582 | |||||||
$313,057.95 | |||||||
$313,057.95 | |||||||
$313,057.95 | |||||||
€ 168,000 | |||||||
€ 65,175 | |||||||
€ 65,175 | |||||||
€ 65,175 | |||||||
€ 177,080 | |||||||
€ 130,652 | |||||||
€ 130,652 | |||||||
$40,400 | |||||||
$40,400 | |||||||
$40,400 | |||||||
€ 164,220 | |||||||
€ 164,220 | |||||||
€ 167,468 | |||||||
€ 88,000 | |||||||
€ 88,000 | |||||||
€ 88,000 | |||||||
€ 756,074 | |||||||
€ 190,765 | € 112,215 | ||||||
€ 113,766 | |||||||
€ 632,640 | |||||||
€ 178,500 | |||||||
€ 566,100 | € 333,000 | ||||||
$493,727.50 | |||||||
€ 1,051,206 | |||||||
€ 197,511 | |||||||
$400,000 | |||||||
$120,000 | |||||||
$60,000 | |||||||
€ 200,000 | |||||||
$400,000 | |||||||
$120,000 | |||||||
$60,000 | |||||||
€ 264,136 | |||||||
$400,000 | |||||||
$120,000 | |||||||
$60,000 | |||||||
Total EUR | |||||||
Total USD |