Add totals in a table with multipul values

[klis]

I think its quite possible that I am being a total retard today…. But here goes my simple question anyway

I have a table which contains peoples orders for items which have different prices.

I would like an easy equation which will count the number of items in each order and multiply by the amount in its column. I seem to be only able to do this long hand by adding each item one by one, but was hoping there was a quicker way?
I also have an “X” marked on items which have not been bought, which is causing a slight conflict….

------

What is shown is only an example, I have around 50 columns, and 100 orders, so kinda annoying to do 1 by 1

Im thinking that I would need some kind of ‘countif’ EQ that would ignore the “X”s?

Id like to be able to do the EQ in Cell I5 and then just drag down for the rest - Is it possible?

I’m using Excel 2003.

[dip11]

Please Login or Register  to view this content.

Copy down the column

Ah you using 2003, in that case:

Please Login or Register  to view this content.

[klis]

I cant thank you enough

+1 for you kind sir.

[JosephP]

i5 =SUMPRODUCT($C$4:$H$4,C5:H5)
and fill down

[klis]

lol ok, that's far simpler.

Both do the same job, so thank you both.

+1 to both

[Kevin UK]

How about SUMPRODUCT.

=SUMPRODUCT(C$4:H$4,$C5:$H5)