| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of a cell if certain criteria are met.
I know this is probably easy, but for some reason I am having a hard time
with it. Here's what I want to do. IF A1=L THEN C1-B1 IF A1=S THEN B1-C1 Not that it matters, but L=Long, S=Short (I trade stocks) If I take a long position, then I need to subtract the entry price from the exit price and vice versa. I would like the sum of that to appear in the cell I put that formula in. Any help would be great! Thanks again! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF, criteria is cell-to-cell comparison | Excel Worksheet Functions | |||
| Change the appearance cell where Find criteria is found in a cell | Excel Discussion (Misc queries) | |||
| Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) | |||
| How do I get info from a cell based on criteria from another cell | Excel Worksheet Functions | |||
| count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
Threaded Mode
