Login Page - Create Account

Support Board


Date/Time: Thu, 22 Jan 2026 23:34:12 +0000



Post From: SUMPRODUCT

[2026-01-22 19:35:49]
User411320 - Posts: 368
Hello, i'm trying to use to 2 formulas using the SUMPRODUCT function and I'm getting #VALUE!. The formulas are as follows

=SUMPRODUCT(100*(E3:E12-B3:B12)/B2:B12)

=SUMPRODUCT(SIGN(E3:E5-B3:B5))


what am I doing wrong