D
Dan
Please help with A formula needed shown after the table
below:
Marital
3 Apt# Name Sex Status Salary
4 101 Bob M S $42,000
5 102 Chris M D $21,000
6 103 Don M M $26,000
7 Val F M $14,000
8 104 Fran F W $18,000
9 105 Ken M S $12,000
10 Jan F S $ 9,000
11 106 Lee M D $36,000
12 107
13 108 Mary F S $28,000
14 109 Pat M S $72,000
15
I need a formula that will count the number of unmarried
couples whose combined income is between $20,000 & $29,999.
In the table above, there is only 1 (Apt# 105). Sorry the
table is long but there are many different scenerios.
(Apt#107 is vacant.)
below:
Marital
3 Apt# Name Sex Status Salary
4 101 Bob M S $42,000
5 102 Chris M D $21,000
6 103 Don M M $26,000
7 Val F M $14,000
8 104 Fran F W $18,000
9 105 Ken M S $12,000
10 Jan F S $ 9,000
11 106 Lee M D $36,000
12 107
13 108 Mary F S $28,000
14 109 Pat M S $72,000
15
I need a formula that will count the number of unmarried
couples whose combined income is between $20,000 & $29,999.
In the table above, there is only 1 (Apt# 105). Sorry the
table is long but there are many different scenerios.
(Apt#107 is vacant.)
10="S")*(E2:E10>=20000)*(E2:E10<=29999))