Login Page - Create Account

Support Board


Date/Time: Wed, 01 Jul 2026 11:24:48 +0000



Post From: SUMPRODUCT

[2026-01-22 19:35:49]
User411320 - Posts: 376
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