Excel Help Please

G18241

G18241

G18241

Soldato
Joined
3 Mar 2004
Posts
7,340
Location
Sheffield
Hi :)

Right im after soemthing done in excel but canno tfor the life of me work out how to do it.

Will try and keep it simple :p

Will have data in 1 table headed: Name, Total, Option A, Option B

Another table will have information added to it daily, in the same format as table 1, but in no order as it will be bulk copy and paste

I need table 1 to count thet total for each "Name", which is a COUNTIF formulae, ive sorted that bit. This will go in the "Total" column

I then need it to have option A and B also do this, BUT it has to be by the "name" so a countif will not work as it will just count everything.

So i need to know a total of how many each name has, but how many of option A they have and also how many of option B they have as well.

Have tried just about everything i know how too, Vlookups, countifs etc but cant work it out :(

Will try and get a screenshot or an ideal end product if all theabove doesnt make much sense.

Any help at all would be very greatly appreciated, and will be rewarded with internets and cookies!
 
Sumproduct I reckon. Though not sure why countif / sumif won't do it for you.
I am assuming that you have numeric values in Option A and Option B and you want them summed ?

Maybe you don't need table 1 at all. If it does no more than summarise Tablev2 then replace it with a pivot table
 
A sumproduct should do what you want.

=sumproduct(($A$1:$A$100="Name")*($A$1:$A$100="OptionA")

as said before a pivot table will work too. Just slam it all in there, have names in your row and drop the option a and option b data into the data fields.
 
Namsnik said:
Sumproduct I reckon. Though not sure why countif / sumif won't do it for you.
I am assuming that you have numeric values in Option A and Option B and you want them summed ?

Maybe you don't need table 1 at all. If it does no more than summarise Tablev2 then replace it with a pivot table
Click to expand...

Could be how ive explained this, i was falling asleep last night as i wrote it :p

Table 1 will have the 2 heading Option A and option B, on the table that has all the data put in it, both option A and B will appear in the same column, so it needs sorting as to which NAME has what amount of each option, and then have this splitting between the two columns in table 1.

WIll have alook at the sumif/sum product, thank you for your help guys ill get back to you if i cant get it to work :)
 
You must log in or register to reply here.
Back
Top Bottom