Count IF

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

i have a spreadsheet with sales info
solo
dsl/voice
voice
cable

now all but dsl/voice count as 1 unit
dsl/voice count as 2

each row is a sale... with info on that sale

username customername date linetype salesperson units

A1 davidjmor David Morin 12/28/09 dsl/voice sboud 2
A2 testuser test guy 12/28/09 solo sboud 1

above is what the row looks like, the linetype is what i want to count....so the username davidjmor would count as 2 units and the testuser would count as 1 unit. now A1 next month might be a "solo" so it would count as 1. how can i change the "units" column to count that cell to see what it is and then apply appropriate number there.

=IF(ISERROR(FIND("/",G4,1)),1,2)

That worked perfect.......Thank you so much!!!!

one last thing...i hate to be a bother but is there a way to make it so that if cell is empty to display 0 or nothing at all?

Originally Posted by deadlyduck

Please Login or Register  to view this content.

should do it for blank cells. Substitute alternative text in quotes (for the red zero) if you don't want a 0 displayed e.g. "no sale"

Thank you so much again man!!! You rock