Forum Discussion
SUMPRODUCT
Hi All, Is there any way I can use sumproduct to count the number of times the difference between Column B and Column C is less than or equal to 1? B-C <= 1 E.g. =SUMPRODUCT(--( B2:B10 - C...
Thank you so much for your help.
One problem I am facing is some rows of C2:C10 are empty.
Is there anyway i can write the formula such that it can still auto-calculate without making changes to the data?
Hello, unfortunately it still gives an error "#VALUE!"
Can anyone help to resolve this?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
