enter 2 formulas into 1 cell (NEW QUESTION)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"))
 
Posted this reply in your earlier thread:
----------------- -----------------
Needs help said:
.. need to add up the totals of the amounts in the cells
only that only contained the word "internet" ..Thanks!
Click to expand...

Assuming B1:B20 contain the amounts to be summed,
with A1:A20 housing text such as "internet"

If you're still talking multi-conditions, then use eg:
=SUMPRODUCT((A1:A20="Internet")*(B1:B20>=100),B1:B20)
which will sum only the amounts >=100 in col B
where col A contains: internet

If it's only for a single condition, use SUMIF, eg:
=SUMIF(A1:A20,"internet",B1:B20)

Think SUMIF will suffice for you here

---
 
Back
Top