G
Guest
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
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