How to sum up with different input?

[MrNewExcel]

How do you sum up different cells with different input? what i'm trying to to do is to have a formula that will sum up the gas product i used. In my excel i have 3 diffrent gas product
but i used different gas product at the same time or sometimes the same gas product. Is there a formula that will automatically compute this. for example if i use shell(i will mark"x")and if i
use caltex(i will mark"x") it will sum up how much i consume in shell, caltex and petron individually. Pls note that Engine No. 3 always use petron gas product.

pls check my excel example. Sorry for the terminology I'm not good in excel. Thank you. Pls help.

GAS PRODUCT MONITOR.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	ENGINE NO.1 CONSUMPTION								ENGINE NO. 2 CONSUMPTION								ENGINE NO. 3 CONSUMPTION (ALWAYS IN PETRON)						OIL Consumption			Consumption (Total)
2	Counter	Density	Temp	[ltr.]	Cons.	SHELL	PETRON	CALTEX	Counter	Density	Temp	[ltr.]	Cons.	SHELL	PETRON	CALTEX	Counter IN	Counter OUT	Density	Temp	[ltr.]	Cons.	Counter	LBS	OHS	SHELL	PETRON	CALTEX
3	69868800	0.9800	130	900	0.8	X			11134700	0.9900	92	900	0.8	X			7979820		0.9800	130	160	0.1	1436690		10	=1.6 (0.8+0.8)	=0.1
4	69869300	0.9800	130	500	0.5			X	11135150	0.9900	92	450	0.4	X			7979930		0.9800	130	110	0.1	1436700		10	=0.4	=0.1	=0.5
5	69869600	0.9800	130	300	0.3			X	11135640	0.9900	92	490	0.5			X	7980020		0.9800	130	90	0.1	1436710		10		=0.1	=0.8
6	69869700	0.9800	130	100	0.1		X		11136270	0.9900	92	630	0.6		X		7980200		0.9800	130	180	0.2	1436710		10		=0.9 (0.1+0.6+0.2)
Sheet1

Cell Formulas
Range	Formula
E3:E6,V3:V6,M3:M6	E3	=ROUND((B3-0.000625*(C3-15))*D3/1000,1)
L4:L6,D4:D6	D4	=IF(A4>0,A4-A3,0)
U4:U6	U4	=IF(Q4>0,(Q4-Q3)-(R4-R3),0)

 

[Zot]

There are more than 1 possible way I think. Mine is this

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	ENGINE NO.1 CONSUMPTION								ENGINE NO. 2 CONSUMPTION								ENGINE NO. 3 CONSUMPTION (ALWAYS IN PETRON)						OIL Consumption			Consumption (Total)
2	Counter	Density	Temp	[ltr.]	Cons.	SHELL	PETRON	CALTEX	Counter	Density	Temp	[ltr.]	Cons.	SHELL	PETRON	CALTEX	Counter IN	Counter OUT	Density	Temp	[ltr.]	Cons.	Counter	LBS	OHS	SHELL	PETRON	CALTEX
3	69868800	0.98	130	900	0.8	X			1.1E+07	0.99	92	900	0.8	X			7979820		0.98	130	160	0.1	1436690		10	1.6	0.1	0
4	69869300	0.98	130	500	0.5			X	1.1E+07	0.99	92	450	0.4	X			7979930		0.98	130	110	0.1	1436700		10	0.4	0.1	0.5
5	69869600	0.98	130	300	0.3			X	1.1E+07	0.99	92	490	0.5			X	7980020		0.98	130	90	0.1	1436710		10	0	0.1	0.8
6	69869700	0.98	130	100	0.1		X		1.1E+07	0.99	92	630	0.6		X		7980200		0.98	130	180	0.2	1436710		10	0	0.9	0
Sheet1

Cell Formulas
Range	Formula
E3:E6,V3:V6,M3:M6	E3	=ROUND((B3-0.000625*(C3-15))*D3/1000,1)
Z3:Z6	Z3	=--(F3="X")*E3+--(N3="X")*M3
AA3:AA6	AA3	=--(G3="X")*E3+--(O3="X")*M3+V3
AB3:AB6	AB3	=--(H3="X")*E3+--(P3="X")*M3
L4:L6,D4:D6	D4	=IF(A4>0,A4-A3,0)
U4:U6	U4	=IF(Q4>0,(Q4-Q3)-(R4-R3),0)

Note:
Expression F3="X" will give value TRUE. A -(F3="X") will give -1. So, double negative --(F3="X") give value 1.

 

[Fluff]

Duplicate to: how create a formula that is autocalculate?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.