Thread: Trading Probability
View Single Post
  #6  
Old 12-18-2008, 06:34 PM
shg's Avatar
shg shg is online now
Forum Guru
  
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 18,543
shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay
=AVERAGE(IF($G$2:$G$16 = "Long", $E$2:$E$16))

Look at the columns it tests and adjust accordingly.

This is an array formula, meaning it MUST be confirmed with Ctrl+Shift+Enter, not just Enter. (With the cursor in the formula bar, hold down Ctrl and Shift, then press Enter.) You'll know you did it correctly if curly braces appear around the formula in the Formula Bar; you cannot type in the braces directly.
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote