I
IanEmery
Hi
I formula that identifies unique entries in a column and counts the
total as shown below:
=SUMPRODUCT(B8:B501<>"")/(COUNTIF(B8:B501,B8:B501&"")))
I am trying to get this formula to work only where a precondition
exists, i.e. that an associated field is set to "yes"
This works fine on normal SUMIF functions as shown below:
=SUMIF(S8:S501,"Yes",P8525)
However when I try o combine the 2 scenarious I receive a Value#
error.
The formula I am trying is shown below:
=IF(S8:S501,"Yes",SUMPRODUCT(B8:B501<>"")/(COUNTIF(B8:B501,B8:B501&"")))
Anyone any ideas?
Many thanks
I formula that identifies unique entries in a column and counts the
total as shown below:
=SUMPRODUCT(B8:B501<>"")/(COUNTIF(B8:B501,B8:B501&"")))
I am trying to get this formula to work only where a precondition
exists, i.e. that an associated field is set to "yes"
This works fine on normal SUMIF functions as shown below:
=SUMIF(S8:S501,"Yes",P8525)
However when I try o combine the 2 scenarious I receive a Value#
error.
The formula I am trying is shown below:
=IF(S8:S501,"Yes",SUMPRODUCT(B8:B501<>"")/(COUNTIF(B8:B501,B8:B501&"")))
Anyone any ideas?
Many thanks