Forum Discussion
Need help with a formula
Hello. I need some help with a formula for counting the total quantity of an item present on a sheet. I have an equipment sheet with similar information to what is shown below that states the num...
I did. I input the correct sheet name and I changed the range from 6 to 300 solely to allow for any additions to be added. The formula returns an error.
I played with it more. Your formula was missing a second ! for the sum range. This looks to be working correctly. now.
Sorry about the missing !
I wrote the formula directly in the post instead of testing it 😞
- Yes, this is working perfectly now. Thank you very much for your help in creating this.
