Add cells based on critera

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

Guest

I need the formula for adding up (the dollar amount) in a separate cell that
contained two criterias from a previous formual...1 had one cell that
contained the word "internet" and 1 cell had a dollar amount figure in it.
example
=SUMPRODUCT((F2:F86="Internet")*(ISNUMBER(M2:M86)))
in a separate cell I need the total dollar amount containing those formuals.
thanks
 
Try either of these:

=SUMPRODUCT((F2:F86="Internet")*M2:M86)

OR, if you might have text in Column M, try:

=SUMPRODUCT(--(F2:F86="Internet"),M2:M86)
 
thank you, thank you, thank you!!

RagDyer said:
Try either of these:

=SUMPRODUCT((F2:F86="Internet")*M2:M86)

OR, if you might have text in Column M, try:

=SUMPRODUCT(--(F2:F86="Internet"),M2:M86)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

enter 2 formulas into 1 cell 2
enter 2 formulas into 1 cell (NEW QUESTION) 1
Formula with multiple critera 2
Enter 2 formulas in 1 cell 6
How to separate contents of one cell into multiple horizontal cell 1
check or uncheck a check box based on a cell value 1
Rounding Effecting Sum 2
List multiple values in seperate cells 7

Back
Top