| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I write this formula in Excel 2003?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I write this formula in Excel 2003?
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 On Sep 10, 1:00*am, anschutz.177 wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I write a macro to show the find dialog box in excel 2003 | Excel Discussion (Misc queries) | |||
| how do i write hindi numerals in excel 2003 | Excel Discussion (Misc queries) | |||
| Can someone write this formula for me in Excel 2003 Language | Excel Worksheet Functions | |||
| How do I write From Excel 2003 to Access 2000? | Excel Discussion (Misc queries) | |||
| Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
Linear Mode
