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.
The double negative refs only negative values in the specified ranges. In other
uses it forces a negative value.
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion