Help With Error In Formula Please

J

Joe Gieder

I have this formula that returns a "#NUM" error and was
hoping someone could help please:

=SUMPRODUCT(--('Priced BOM'!$L:$L="Purchase History"),--
('Priced BOM'!$W:$W<TODAY()-1095),--('Priced BOM'!
$W:$W>=TODAY()-1460))

It counts the number of Purchase History items that are
over 3 years and less than 4 years old.

Thank you for the help and support you all offer people
like me that are eager to learn more and sometimes run
into problems.

Joe
 
J

Joe Gieder

Sorry, wrong newsgroup. Should have been Excel but if
anyone can help that would be great.

Joe
 
Top