Good morning all,

Issue: I use the following formula to display data:

=SUMPRODUCT(--('Daily Reading Master
Log'!B$3:B$211=DATEVALUE("02/01")),--('Daily Reading Master
Log'!B$3:B$211<=DATEVALUE("2/28")),'Daily Reading Master
Log'!BW$3:BW$211)/SUMPRODUCT(--('Daily Reading Master
Log'!B$3:B$211=DATEVALUE("02/01")),--('Daily Reading Master
Log'!B$3:B$211<=DATEVALUE("2/28")))

Problem:
Where this calculation is performed on a set of data that has no values, I
get the 'DIV/0' error. I understand why this occurs, however:

Question:
How can i add an 'IF' component to this equation, such that if the result of
hte calculation is 'DIV/0, display 'N/A', rather than the DIV/0 error

Many thanks in advance,


--
Carlee