One way:

=SUMPRODUCT(--(A1:A1000="internet"),--(B1:B1000="something else"))

In article ,
Needs help wrote:

I need to enter 2 formuals in one cell and I do not know what the formula
should be. Example....I need to count the number of cells that contain the
word "internet" but only if in another cell it has an amount in it. Any
ideas? Thanks!