#NUM! Error

Giganews Newsgroups
Subject: #NUM! Error
Posted by:  Dick (bobdel…@yahoo.com)
Date: Wed, 19 Jan 2011

Getting #NUM! error with this formula
=SUMPRODUCT((Sheet1!A:A="Alkalume 143")*(Sheet1!B:B="January"),Sheet1!
D:D)
Can someone help as to why.
Using excel 2003, saved as xls
Thanks in advance

Replies