Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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