Andreamary
asked on
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
{=SUM(IF(ISERROR(Y2:BI2),"
I need to revise the above formula to exclude the following 3 cells: AV2, AY2, BB2
Thanks,
Andrea
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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))}
Regards
ASKER
I tested all the solutions offered and this is the solution that worked properly. Thanks very much!
pls try
Open in new window
Regards