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
				
			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: 
			
		
	
								
								
									
	
								
							
							