enter 2 formulas into 1 cell (NEW QUESTION)

N

Needs help

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"))
 
D

domenic22

For a single condition...

=SUMIF(Range,Criteria,RangeToSum)

For two or more conditions...

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

Hope this helps!
 
R

RagDyer

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

See answer to your later thread.
 
Top