Timesheet adding rows
Closed
nicoleevelyn
Posts
1
Registration date
Thursday February 23, 2017
Status
Member
Last seen
February 23, 2017
-
Feb 23, 2017 at 02:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 27, 2017 at 11:11 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 27, 2017 at 11:11 AM
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Updated by TrowaD on 27/02/17 at 11:11 AM
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.