Depending on your windows settings, that semicolon (;) could be a comma (,).

And the =sumproduct() suggestion will actually add all the values in C2:C1000 if
column A has "corporate marketing" and at the same time, column B = "critical".

That means that C2:C1000 will have to be numeric for these rows.

The other suggestion picks off the first match it finds and only returns that
single value.

paula k wrote:

Thank you for answering so quickly..it is still not working though...is the
";" correct? I get an error around that ... excel suggests to change it to a
"*"

then when it does change, I get a "Value" error...any help??!

"Marcelo" wrote:

hi Paula,

=sumproduct(--(a2:a1000="Corporate
Marketing")*(b2:b1000="Critical");(C2:C1000))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"paula k" escreveu:

Here is the data I am working with:

LOB C/N #
Corporate Marketing 2
Corporate Marketing Critical 1
Corporate Marketing Non-Critical 1
Corporate Safety 1
Corporate Safety Critical 3
Corporate Security 1
Corporate Security Critical 1

How do I search for a lookup a "Corporate marketing" and "Critical" to
return the number from column 3?

Thanks!!!!


--

Dave Peterson