On Mar 31, 11:34*pm, Pete_UK wrote:
You can't use a full-column reference with the SUMPRODUCT function
(and with array formulae), but you can with COUNTIF and SUMIF (and
many others).

Pete

On Mar 31, 9:56*pm, wrote:





Oh really? I didnt know that, well it never goes over 2000, so i can
program it up to that - its just a BETA at the moment though, so i
wont to test it. I didnt realise you cant use full column references,
its strange you say that cos my other formula, the original COUNTIF
works with a full column reference??
Anyway, I will give this ago - thanks- Hide quoted text -

- Show quoted text -

This worked brilliantly, thankyou.
Now I want to Add the values of Column D - which is the money of each
entry, but only if it is 'ticked'... so basically I want to use the
formula you have provided, then tell it that "where this applies -
SUM of Column D" .. if that makes sense??
Thanks if you can help...