This is my working formula
![]()
=SUMPRODUCT(--($R$3:$R$28=88398),N$3:N$28,$P$3:$P$28)
I want to make it an OR condition by having $R$3:$R$28=88676 as another option. I've tried the following formula.
and![]()
=SUMPRODUCT(-(IF($R$3:$R$28=88676,(O$3:O$28),1),IF($R$3:$R$28=88676,($P$3:$P$28),1)))
I'm getting a value error and can't figure out where the problem is.![]()
=SUMPRODUCT(OR(--($R$3:$R$28=88398),(--($S$3:$S$28=88398)),N$3:N$28,$P$3:$P$28))
Any help is appreciated.
Thanks,
BDB
Bookmarks