Hi, I am looking for a formula to sum up numbers in a table where I need have every other column value to be summed up only if adjacent column is a non-empty cell.
I have attached file for your reference.
Hi, I am looking for a formula to sum up numbers in a table where I need have every other column value to be summed up only if adjacent column is a non-empty cell.
I have attached file for your reference.
Maybe:
Formula:Please Login or Register to view this content.
Good luck!
I think Estevaoba has it, but you can shorten his formula a little:No need to check for ACT, the offset ranges already yield proper alignment.Formula:Please Login or Register to view this content.
Last edited by leelnich; 05-12-2023 at 09:06 PM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks