search multiple columns and count number of rows the keywords appear

[vincegc8]

i attached a sample set of data.

theres a list of keywords associated with a product.

I want to count how many "steering wheels" and 'shift knobs" were sold in each month. But since the data is spotty I can't just search a single column. When I'm searching multiple columns its return a result for each of the time it finds the word. Each row should only be counted once.

[Moo the Dog]

While I don't have a solution to your question, I will offer some advice... use Data Validation to prevent different values being typed in to the same area. You could create a list of parts that can be entered, and use that list for DV in a column. Much easier to work with data when it is organized.

- Moo

[vincegc8]

thanks for the tip.

but thing is that im going old data that was entered poorly. the current data has good formatting and doesn't require this. but the data that i need to summarize is from years back and would take forever to manually filter and count.