# Put Option Real Estate

Document Sample

```					Basic SUMIF                      You use the basic SUMIF when you want to sum up a set of values that me

Values     Option 1
100   Criteria      >20
101   Sum              1,605.00
102
103   Option 2
104   Sum                1,605.00
105
106
107
108
109
110
111
112
113
114

Advanced SUMIF                   SUMIF can also be used to sum up values based on a corresponding set o

Month        Values     How do we sum all of the values that correspond to the months that are gre
1        100
2        101   Option 1
3        102   Criteria      >6
4        103   Sum                     990
5        104
6        105   Option 2
7        106   Sum                     990
8        107
9        108
10        109
11        110
12        111
13        112
14        113
15        114

SUMPRODUCT                       What do we do if we want to run simultaneous SUMIFs? While there is a S

Lower Limit       Upper Limit       Sumproduct
Criteria                    4          10             530
Month        Values
1         100                               0           1
2         101                               0           1
3         102                               0           1
4         103                               0           1
5         104                               1           1
6         105                               1           1
7       106                               1           1
8       107                               1           1
9       108                               1           1
10       109                               1           0
11       110                               1           0
12       111                               1           0
13       112                               1           0
14       113                               1           0
15       114                               1           0

Array Formula
Can we acheieve multiple SUMIFs without using SUMPRODUCT? Yes, we
Month        Values
1        100   Sum                      530
2        101
3        102   After you write out the formula, simply click into the cell and press control-s
4        103    Excel will then turn the formula into an array formula and apply it to the en
5        104
6        105   Array formulas are extremely powerful as they can condense complex calc
7        106
8        107
9        108
10        109
11        110
12        111
13        112
14        113
15        114
p a set of values that meet a certain criteria.

on a corresponding set of values such as months that correspond with cash flows.

o the months that are greater than 6?

MIFs? While there is a SUMIFS function in Excel 2007, it's not backward compatible with Excel 2003. We can use SUMPRODUCT instead to

Sumproduct
<-- This is the sum of the values to correspond to months that are greater than 4 and less than 10.
UMPRODUCT? Yes, we can do so through the use of an array formula.

e cell and press control-shift-enter to put braces around the formula.
ula and apply it to the entire array.

condense complex calculations into single cells.
SUMPRODUCT instead to generate the same result.

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 4 posted: 8/1/2011 language: English pages: 5
Description: Put Option Real Estate document sample