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 .

Weight	Date	Weight	Date	Weight	Date	Weight	Date	Total
1	1 March	2	1 March	3	5 March	2	2 Feb	8
1		2	1 March	3		2	5 Feb	4

<tbody>
</tbody>

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