|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How do I correct error using the =IF(AND(formula in excel?
Thanks Bernard
"Bernard Liengme" wrote:
No need for double negatives when you use * operator, only when the two
arrays are set apart by comma as in
=SUMPRODUCT(--(B1:B4=DATE(2006,1,1)),--(C1:C4=A1))
See http://mcgimpsey.com/excel/formulae/doubleneg.html
wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Duke Carey" wrote in message
...
=SUMPRODUCT(--(B1:B4=DATE(2006,1,1))*--(C1:C4=A1))
!
|