Crashed with 'Fatal Error' when I tried to download it.

"Brian" wrote:

Chris,

You need to use THREED('1:31'!E1:E60) in your SUMPRODUCT formula. THREED
isn't standard and you need to get it as an add-in. I believe it's Morefunc
available at http://xcell05.free.fr/

v/r
--
Brian


"chrisk" wrote:

I've read through loads of the examples but cant seem to get them to work.
Column E has text (a job) column I has a name (JW).
there are 31 sheets (one per day) in the workbook.
On sheet 32 (just added) i want to total how many jobs JW has done in the
month.
Tried using
=SUMPRODUCT(--('1:31'!E1:E60="*"),--('1:31'!I1:I60="JW"))
but it keeps changing to
=SUMPRODUCT(--('1:[31]31'!E1:E60="*"),--('1:[31]31'!I1:I60=E4))
how do I get around this?
Thanks