Sum product formula with conditions
On 7/17/2019 9:46 AM, TIMOTHY wrote:
Thank you Alan & Rover
I have searched on google and found out the formula
=sumproduct(--(Range1,criteria1),--(Range2,criteria2),Range3,Range4)
=sumproduct(num(Range1,criteria1),num(Range2,crite ria2),Range3,Range4)
I don't know who started this idiom of a double-negation operator
instead...but it's a least confusing to read if nothing else and seems
less efficient besides.
--
|