Hello to everyone. I really need an answer to this question. anyone that can help, it is extremely appreciated.
I have a database that has a number column, which relates to a text colum. the text colum has two differnt types of information in it. i need to add the number column, but only for certain data in the text colum. Example
number column / text column
523 / hats
309 / shoes
9485 / hats
99 / hats
38 / shirts
38578 / hats
i need a total of the numbers for the hats only. can anyone help me with the formula. thank you.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!