Hi Alan,

I'd say you have a couple of options....

1 Get rid of #N/A in column T then the formula I posted should work.
What formula are you using in T?

2 Switch to a CSE formula which can be constructed to ignore error
values in column T, i.e.

=SUM(IF(ISNUMBER(Selling!T5:T30000),IF(Selling!F5: F30000="Laser
printers
mono",IF(Selling!A5:A30000=--F1,IF(Selling!A5:A30000<=--F2,Selling!H5:L30000*Selling!T5:T30000)))))

This needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces
appear around the formula in the formula bar


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=506593