Add the weight when date is provided.

[nitishshr]

I would like to add weight of items which are delivered. That is if an item has along side a date then add that item to total else do not add that item.
Please provide me formula. There will be 1000 + such rows and 10+ column .

[TABLE="width: 500"]
<tbody>[TR]
[TD]Weight[/TD]
[TD]Date[/TD]
[TD]Weight[/TD]
[TD]Date[/TD]
[TD]Weight[/TD]
[TD]Date[/TD]
[TD]Weight[/TD]
[TD]Date[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1 March[/TD]
[TD]2[/TD]
[TD]1 March[/TD]
[TD]3[/TD]
[TD]5 March[/TD]
[TD]2[/TD]
[TD]2 Feb[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]1 March[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]5 Feb[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]


Add the Weight if Date is provided at the right.
Don't add weight if Date is not provided at the right.


Thank you.

 

[wideboydixon]

Book1
	A	B	C	D	E	F	G	H	I
1	Weight	Date	Weight	Date	Weight	Date	Weight	Date	Total
2	1	01-Mar	2	01-Mar	3	05-Mar	2	02-Feb	8
3	1		2	01-Mar	3		2	05-Feb	4
Sheet1

Cell Formulas
Range	Formula
I2	{=SUM(IF(MOD(COLUMN($B2:$H2),2)=0,IF($B2:$H2<>"",$A2:$G2)))}
Press CTRL+SHIFT+ENTER to enter array formulas.

Some things to note:

1. Change $B2:$H2 to be the first and last cells of the dates on the row
2. Change $A2:$G2 to be the first and last cells of the weights on the row
3. If the dates are in an odd numbered column (A, C, E etc.) then change the =0 to be =1

WBD