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!

For a single condition...

=SUMIF(Range,Criteria,RangeToSum)

For two or more conditions...

=SUMPRODUCT(--(RangeX=CondX),--(RangeY=CondY),RangeToSum)

Hope this helps!

On Nov 1, 3:07 pm, Needs help
wrote:
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!

Why are you starting so many threads on the same subject?

See answer to your later thread.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Needs help" wrote in message
...
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!

thank you, thank you, thank you!!

" wrote:

For a single condition...

=SUMIF(Range,Criteria,RangeToSum)

For two or more conditions...

=SUMPRODUCT(--(RangeX=CondX),--(RangeY=CondY),RangeToSum)

Hope this helps!

On Nov 1, 3:07 pm, Needs help
wrote:
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!