Add cells based on critera

N

Needs help

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
 
R

RagDyer

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)
 
N

Needs help

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...
 
Top