Free for PREMIUM members
[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now
activecell.FormulaArray = "=SUM(IF(SUBTOTAL(2,OFFSET(RC:RC,ROW(RC:RC)-MIN(ROW(RC:RC)),,1)),RC:RC,0))"
Open in new window
=SUM(IF(ISNA(A1:A6); 0; A1:A6))
Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.