[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

Excluding specific cells from array formula

I am using this array formula to get the total number of minutes:
{=SUM(IF(ISERROR(Y2:BI2),"",Y2:BI2))}

I need to revise the above formula to exclude the following 3 cells: AV2, AY2, BB2

Thanks,
Andrea
0
Andreamary
Asked:
Andreamary
  • 2
1 Solution
 
Rgonzo1971Commented:
HI,

pls try

{=SUM(IF(ISERROR(Y2:AU2);"";Y2:AU2))+SUM(IF(ISERROR(AW2:AX2);"";AX2:AX2))+SUM(IF(ISERROR(AZ2:BB2);"";AZ2:BB2))}

Open in new window

Regards
0
 
Saqib Husain, SyedEngineerCommented:
Try

=SUM(IF(ISERROR(Y2:BI2)+NOT(ISERROR(FIND((ADDRESS(ROW(Y2:BI2),COLUMN(Y2:BI2))),"$AV$2,$AY$2,$BB$2"))),"",Y2:BI2))
0
 
Rgonzo1971Commented:
With commas instead of semicolons

{=SUM(IF(ISERROR(Y2:AU2),"",Y2:AU2))+SUM(IF(ISERROR(AW2:AX2),"",AX2:AX2))+SUM(IF(ISERROR(AZ2:BB2),"",AZ2:BB2))}

Open in new window

Regards
0
 
AndreamaryAuthor Commented:
I tested all the solutions offered and this is the solution that worked properly. Thanks very much!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now