Purchasing items calculation

[Spikenaylor]

Hi there

I need to get a total price for the items purchased.
My data looks like. Person one has bought the quantities of items listed, I just need to sum up the total

	Title1	Title2	Title3	Title4	Title5	Title6	Title7	Title8	Title9	Title10
	£1.01	£0.96	£2.56	£1.43	£0.77	£1.78	£2.05	£3.10	£0.60	£0.50
Person 1		1		2		1		1			£8.70​

I can do the long summing, but is there an easier calculation that can total up the amount?

Regards

 

[diddi]

try

=Sumproduct(B$2:K$2,B3:K3)

 

[Spikenaylor]

try

=Sumproduct(B$2:K$2,B3:K3)

Many thanks

 

[Fluff]

How about

=SUMPRODUCT(--(B3:K3<>""),B3:K3,$B$2:$K$2)

 

[pjmorris]

Hi Fluff, why have you included the additional conditional clause? What does it protect against?

As ever - still learning.

Regards

 

[Fluff]

Just habit & a lack of

 

[pjmorris]

Just habit & a lack of

excellent, we form habits for a reason!