Forum Discussion
Request for assistance on how to use sumproduct to calculate counts of Full and partial payment
You need to stop using X:X or N:N, I think the problem is the 1st row which is text
N:N should be replaced by N2:N3081 also applies to P:P
then if a client pays 99% or more, you consider him/her full payment, that is why you need to work with >0.99 not 1
see the attached file, hope it solved the problem
if it does, please assign the post as solved and I would love a like 🙂
Thanks for the response but what i want is a formula that would calculate the count out of the column P (June-2020) divided by column N which would display as count of 264 for full payment and 16 for partial payment without necessarily depending on the formulas in columns (X:X ) and columns (Y:Y). I want the formulas to stand on it own without a helper column. Hope this finds you well.
Regards,
Kwabena.
You need to stop using X:X or N:N, I think the problem is the 1st row which is text
N:N should be replaced by N2:N3081 also applies to P:P
then if a client pays 99% or more, you consider him/her full payment, that is why you need to work with >0.99 not 1
see the attached file, hope it solved the problem
if it does, please assign the post as solved and I would love a like 🙂
Thanks again the columns are those highlighted in red and yellow on their respective tabs.
Please find the modification, but yet I am understanding this application 100%
so please tell me if the numbers make senese