getting error on counting function. Take a look at the welders tab, not sure where im going wrong. Using formula in other areas with no problem
getting error on counting function. Take a look at the welders tab, not sure where im going wrong. Using formula in other areas with no problem
Four of the XR CNT for welder P-5 have an error message.
remove all filters, and then filter column S to show only the "#Value" entries, and you will see the issue.
Solving those lines is the core issue.
Please click the * icon below if I have helped.
On tab "welders data", cells S3441:S3444 (relating to "P-5") result in a "Value" error >> Sumif value error.
Your formula:
=SUMIF('WELD DATA'!L:L,"P-5",'WELD DATA'!S:S)
You are trying to sum a column that only has P-5 in it and WELD DATA'!L:L,"P-5" results in an error
The other formulas work because they do not include "P-5"
Click on star (*) below if this helps
you have errors in cells S3441:S3444
Also, if you change the formula to
=SUMIF('WELD DATA'!L:L,$B5,'WELD DATA'!S:S)
you can just copy it down without needing to change the reference each time
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks melvinrobb that fixed it. rep added
@ K m, i dont think that is the problem, the OP has filters set on that upload to only show P-5. if you remove all the filters, there are other values in that column, bit column S has #value errors in it
Your cells 3441 to 3444 in row R of tab WELD DATA are not empty.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks