Windows XP IF Then statement

Joined
Aug 15, 2008
Messages
1
Reaction score
0
Hi, Very new to this posting..Here is my problem;

I am tracking quotes and I want to have all "2"s added together in one cell, all "1"s the same and all "0"'s the same;
column f column g

row
11 1,000 2
12 4,000 1
13 2,000 2
14 5,000 0
15 2,500 1
16 3,900 0
17 2,000 2
18 4,300 0
19 500 2

I was successful getting one cell correct by doing the following;

=IF(G11>1,$F$11)

However, I want all the 0's, 1,s and 2's to add together and give me a running total in a specific cell

like the following;

Totals;

yes pending no


yes=2
pending=1
no=0

can you help?

Thanks,

AMGSR
 
Last edited:
Back
Top