i have a workbook that im trying to make...almost done thank god...trying to figure one thing out though.

i have this formula : =COUNTIF(line," solo")

what i would like to have this do is to check a singular cell for multiple words
example:

g4 contains the word "solo"
g5 contains the word "dsl/voice"
now "solo" would count as 1 unit and "dsl/voice" would count as 2 units
How can i have this formula do this so it searches each word but only counts it if it is present? also if it contains the "dsl/voice" to times that by 2?

Each month these lines change.


I hope thats clear hehe

Thanks for all the help guys