=SUMPRODUCT((K8:CQ8B7)*(K9:CQ9 <""))

SUMPRODUCT ain't SUMIF, you don't concatenate the operator and the cell like
that.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Antonio" wrote in message
...
Hi to everyone,
I have just discovered sumproduct for multiple conditions in sum and
count!
It´s great, but cannot make it work...
I have a table and need to count the values in a row which are not blank,
but only starting from a certain value of a list in another row (set by a
reference in another cell).

What i´m trying is:
=SUMPRODUCT((K8:CQ8 "&B7")*(K9:CQ9 <" ")) ---B7 is the ref cell
containing the value from which i have to start counting the non blank
cells

In the present situation (in my worksheet), there is only one value in the
whole row (which is in a column further than the value in the second
condition). This should give me 1 but gives 0 and I cannot understand why!

If anyone can help, it would be greatly apreciated!
Thanks,
Antonio