Thread: Condition Command Problem

Can you help me with creating the following excel spreadsheet formula.....I need to do the following:

a) search for a number, for example, "1" by COLUMN.

b) Once "1" is found in a COLUMN, it takes the dollar amount and adds them together $210+173+289+296 and places the total sum in a separate box called "amount"

c) However, if there are more then one "1" in a single ROW, the program should only count it once. For example, in COLUMN 1 and 2, there are two "1" in ROW 4 below, the two "1" are only counted once and the program only records one $289 for those columns and row.


7 1 6 $210
9 9 0 $196
2 4 1 $173
1 1 8 $289
1 8 7 $296
3 3 3 $132
5 7 7 $276
6 6 6 $287
7 6 4 $261

I'm having trouble creating this code. Any help will be greatly appreciated.

maybe like this

=SUMPRODUCT((((A1:A9=1)+(B1:B9=1)+(C1:C9=1))>0)*D1:D9)