Timesheet adding rows
Closed
nicoleevelyn
TrowaD
- Posts
- 1
- Registration date
- Thursday February 23, 2017
- Status
- Member
- Last seen
- February 23, 2017
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Timesheet adding rows
- Automatically data to another sheet by adding new rows ✓ - Forum - Excel
- Microsoft save as pdf ads on - Download
- Ads in hotmail inbox - Guide
- Instagram ads restricted - Guide
- Paste data below the last used row - Guide
1 reply
TrowaD
Updated by TrowaD on 27/02/17 at 11:11 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Updated by TrowaD on 27/02/17 at 11:11 AM
Hi Nicoleevelyn,
Give the following formula a try:
=SUMIF(C2:C20,"<>"&"",B2:B20)
When the cell in column C is not empty, the corresponding cell in column B is added to the total.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Give the following formula a try:
=SUMIF(C2:C20,"<>"&"",B2:B20)
When the cell in column C is not empty, the corresponding cell in column B is added to the total.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.