excelhelpmepls1
New Member
- Joined
- Feb 14, 2024
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi! I need help with this, I need to add the data within a row from January till the month today.
Hope you could help me with the formula, no VBA codes please. The only solution I can think is to transpose the date then use hlookup for the target, then use sumifs. But I'm hoping to skip transpose and hlookup part. Thank you!
Month | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 |
Target | 5000 | 10000 | 12000 | 15000 | 20000 | 20000 | 13000 |
Hope you could help me with the formula, no VBA codes please. The only solution I can think is to transpose the date then use hlookup for the target, then use sumifs. But I'm hoping to skip transpose and hlookup part. Thank you!