Aligning rows, across 3 columns

**dpsersimon** · 05-26-2013, 08:19 PM

Hi Guys,

I am working on some data that is split into 3 columns, and shows the number of graduates of each course either, A-Working full time D-Working part time, looking for full time work G-Not working, looking for full time work.

I am trying to calculate the totals e.g Working full time + Working part time + Not working, for a Bachelor of Accounting but because the rows are not matched up I will have to go through manually and match them up.

Does any one know how I can match the rows up by the name? Or get a sum out with out matching them? I have attached a file with the numbers removed and replaced with 'x'.

Your help is greatly appreciated,

Simon

**FDibbins** · 05-26-2013, 08:33 PM

Try this, copied down...
=COUNTIF(A:G,A2)

**benishiryo** · 05-26-2013, 08:37 PM

hi Simon, putting in some fictitious numbers & then telling us what should the answer be would be so much more helpful for us. i can only guess that you want this right now. assuming the text "Bachelor of Accounting" is in J2, then:
=SUMIF($A$2:$G$304,J2,$B$2:$H$304)
that will sum up column B, E & H if Column A, D & G is exactly "Bachelor of Accounting"

but if you want to sum up those that contains "Bachelor of Accounting", then:
=SUMIF($A$2:$G$304,"*"&J2&"*",$B$2:$H$304)

**dpsersimon** · 05-26-2013, 08:40 PM

Thanks for the quick reply FDibbine,

It does not seam to be doing the job, sorry about my lack of expertise, but could you clarify copy down?

**FDibbins** · 05-26-2013, 08:47 PM

Put that I2 and copy down to the end of your data

**dpsersimon** · 05-26-2013, 08:52 PM

Hi guys,

Thanks again for the great responses, I ended up stacking the 3 columns together and using a pivot to pull out the sums for each of the courses with the same name. Don't know why I didn't think of it earlier.

Thank you very much for you help!