Is there a way I can add an "or" into this formula?
=SUMPRODUCT(--(BE2:BE1364&""="4"),--(BN2:BN1364&""="1"))
I'd like to be able to tally the entries in BE which equal 4s or 3s + entries in BN which are 1s [and possibly other columns and entries)
Also, if anyone feels like letting me know [how these formulas really work, and how I can learn them better], I'm curious to know what the --s indicate in this formula?
Thanks!!!!
=SUMPRODUCT(--(BE2:BE1364&""="4"),--(BN2:BN1364&""="1"))
I'd like to be able to tally the entries in BE which equal 4s or 3s + entries in BN which are 1s [and possibly other columns and entries)
Also, if anyone feels like letting me know [how these formulas really work, and how I can learn them better], I'm curious to know what the --s indicate in this formula?
Thanks!!!!