Foruma to calc full and half

[Erkjerk]

Hi,

Row A has 1-16. Row B1 is labeled Full/Half. Row C1 is labeled Done. Row D1 is labeled total.

If in cell row b2 is typed full, it calculates 1 in total. If half is typed, it would calculate .5 to the total. If it could also only calculate if you type yes in cell c2-c16.

Hope this makes sense. Having real problems figuring it out. Thanks

 

[JoeMo]

Copy D2 down to row 16.

Excel Workbook
	A	B	C	D
1	1	Full/Half	Done	Total
2	2	half	yes	0.5
3	3	full	yes	1
4	4
5	5
6	6
7	7
8	8
9	9
10	10
11	11
12	12
13	13
14	14
15	15
16	16
Sheet11

 

[jtakw]

Hi,

Possibly you mean this?

But don't know if you're looking for a "Running" Total?

Book1
	A	B	C	D
1		Full/Half	Done	Total
2	1	Full	Yes	1
3	2	Full
4	3	Half	Yes	1.5
5	4	Half
6	5	Half	Yes	2.5
7	6	Full	Yes	6
8	7	Full
9	8	Full	Yes	8
10	9	Half	Yes	4.5
11	10	Half	Yes	5
12	11	Half
13	12	Full
14	13	Full	Yes	13
15	14	Half
16	15	Full	Yes	15
17	16	Full	Yes	16
Sheet56

Cell Formulas
Range	Formula
D2	=IF(C2="Yes",A2*IF(B2="Full",1,0.5),"")

Formula copied down.

 

[Erkjerk]

Anyway for the total to add up in d2 rather then a running total? No biggy if it can't just curious. Thanks again.

 

[jtakw]

Here's Cumulative and Running Totals, and Single cell Total:

Book1
	A	B	C	D	E	F	G
1		Full/Half	Done	Total	Cumulative Total	Running Total	Single Result
2	1	Full	Yes	1	1	1	72.5
3	2	Full
4	3	Half	Yes	1.5	2.5	2.5
5	4	Half
6	5	Half	Yes	2.5	6	5
7	6	Full	Yes	6	15.5	11
8	7	Full
9	8	Full	Yes	8	33	19
10	9	Half	Yes	4.5	62.5	23.5
11	10	Half	Yes	5	125.5	28.5
12	11	Half
13	12	Full
14	13	Full	Yes	13	259	41.5
15	14	Half
16	15	Full	Yes	15	520	56.5
17	16	Full	Yes	16	1041	72.5
Sheet56

Cell Formulas
Range	Formula
D2	=IF(C2="Yes",A2*IF(B2="Full",1,0.5),"")
D3	=IF(C3="Yes",A3*IF(B3="Full",1,0.5),"")
E2	=IF(C2="Yes",SUM(E$1:E1,A2*IF(B2="Full",1,0.5)),"")
E3	=IF(C3="Yes",SUM(E$1:E2,A3*IF(B3="Full",1,0.5)),"")
F2	=IF(C2="Yes",SUM(IFERROR(LOOKUP(9.99999999999999E+307,F$1:F1),0),A2*IF(B2="Full",1,0.5)),"")
F3	=IF(C3="Yes",SUM(IFERROR(LOOKUP(9.99999999999999E+307,F$1:F2),0),A3*IF(B3="Full",1,0.5)),"")
G2	=SUM(SUMIFS(A2:A17,B2:B17,"Half",C2:C17,"Yes")*0.5,SUMIFS(A2:A17,B2:B17,"Full",C2:C17,"Yes"))

Formulas copied down.

EDIT: added single cell result in Column G

 

[jtakw]

Ignore D3, E3, F3 formula above.

Just choose D2, E2, or F2 formula and copy down, Or use Single cell formula in G2.