Is there a way do to this without array formula or vlookup
one way
=SUMPRODUCT(--(InpBox2='1STqtrTax'!C7))
Are there better ways? (Isn't SUMPRODUCT truly an array formula?
--
Wag more, bark less
"Brad" wrote:
{=IF(OR(C5=InpBox7),1,0)}
works
=IF(OR(C5={16,17},1,0)
works
Can a formula be written without using vlookup or array formula's and using
InpBox7 ?
InpBox7 is a range name of two cell with the values 16,17
--
Wag more, bark less
|