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: