One way is to try sumproduct, something like this in say, C1:
=sumproduct((a1:a10="internet")*(b1:b10<""))
Adapt the ranges to suit

a1:a10 is where the text "internet" would appear, while
b1:b10 would contain the amounts, if any
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Needs help" wrote:
I need to enter 2 formulas 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!