How do I write this formula in Excel 2003?

A

anschutz.177

Is this formula possible in Excel 2003?
I would like to add the cells in column "K" with the following conditions.

If I4 contains a "J" then add K4 unless L4 contains an "X"

The column "I" would contain the letter "J" or "P".
The column "L" would contain an "X" or be empty.
Column "K" would contain a currency.
 
P

Pete_UK

Try this:

=SUMPRODUCT(--(I4:I50="J"),--(L4:L50=""),K4:K50)

I've assumed data up to row 50, so adjust if you have more.

Hope this helps.

Pete
 

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

Is this formula possible in Excel 2003? 1
Comparing Dates in 4 Columns - Nested Formulas? 2
Array gives wrong answer 1
Help with formula 3
Help with nested conditional formula 1
Vlookup or Other vs Sort? 1
Nested if formula question 3
Test cells for values if date matches 1

Top