Excel experts please help!!

BigDannyO

BigDannyO

BigDannyO

Associate
Joined
15 Jul 2006
Posts
1,030
I'm trying to set up a stock report for work, and have come to an abrupt stop with the calculations!!

Basically i have a table of data in Excel like this:
Shoes: 3
Socks: 2
Socks: 1
Knives: 6
Cats: 0

What i want is a formula to look in that table, and tell me the total number of socks, for example. I have used VLOOKUP so far, but this just looks through the table and gives me the first value for 'socks' it sees, rather than the total!!!

It's driving me mad, i know what i want but i just can't figure it out! :mad:

Please someone help me :)
 
=SUMIF(A1:A4,"socks",B1:B4)

assuming "socks" is in column A and figures are in column B.
 
Last edited:
BigDannyO said:
I'm trying to set up a stock report for work, and have come to an abrupt stop with the calculations!!

Basically i have a table of data in Excel like this:
Shoes: 3
Socks: 2
Socks: 1
Knives: 6
Cats: 0

What i want is a formula to look in that table, and tell me the total number of socks, for example. I have used VLOOKUP so far, but this just looks through the table and gives me the first value for 'socks' it sees, rather than the total!!!

It's driving me mad, i know what i want but i just can't figure it out! :mad:

Please someone help me :)
Click to expand...

If you are looking to pull all that data together and summarise it you could also try the Consolidate option under the Data menu. It will create a table with a single line for each type, e.g. Shoes, Socks, Knives, Cats, and a total for each one. :p
 
You must log in or register to reply here.
Back
Top Bottom