Hi :-D
Using Crystal Reports XI
=SUMPRODUCT(--($G:$G=$E3),--($L:$L="WED"))
This formula above, is counting the number of times the contents of Cell E3 (a name/phone number combo) occur in the cells of Column G, where the equivalent row in Column L contains "WED"
Reference Cell E3 contains the persons name.
My problem is, the Column G data cells, may contain MORE info than is in Cell E3 (EG Name/phone number combo PLUS a comment), making it not match.
At the moment it only includes where the cell in column G totally matches E3. I need it to count these other cells aswell.
Any help would be appreciated.
PS - I've inherited this formula so don't fully understand the double-negative impact.
Thanks
Using Crystal Reports XI
=SUMPRODUCT(--($G:$G=$E3),--($L:$L="WED"))
This formula above, is counting the number of times the contents of Cell E3 (a name/phone number combo) occur in the cells of Column G, where the equivalent row in Column L contains "WED"
Reference Cell E3 contains the persons name.
My problem is, the Column G data cells, may contain MORE info than is in Cell E3 (EG Name/phone number combo PLUS a comment), making it not match.
At the moment it only includes where the cell in column G totally matches E3. I need it to count these other cells aswell.
Any help would be appreciated.
PS - I've inherited this formula so don't fully understand the double-negative impact.
Thanks