Now in a separate cell I need to add those dollar amounts that were the
outcome of my previous formula...
example...I need to know the total dollar amount of the cells that had an
amount that contained the work "internet"...sorry if confusing didn't know
the exact way to word it..... thanks!


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!