|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
10-29-2007, 01:09 PM
|
|||
|
|||
|
Sum of 3 rows into 1, no numbers, different sheets
Ive racked my brain and nothing comes up..I know its not hard, but cant think of it.
This is for a Military Awards tracking system. We have to track by the following standard: Award Type Service type Grade(of individuals) Spread sheet is set up: Row 1: LOM / MSM / ARCOM / and so on Row 2: RET / SVC / ACH (same for each award above) Column A: is the grade, A3 is O10(General), down to A26 is E1(Private) We have to make it, so that we know how O10's (Generals) have a LOM that are RET or SVC or ACH, and E1's(Privates) have a ARCOM that are RET or SVC or ACH and so on. The info sheet is sheet1, the spreadsheet is on sheet3. I think because its on a different sheet, thats what making me lose it. Thanks for any help recieved. "Bring 'em Home or Send Us Back" - POW/MIA! 
|
|
#2
10-29-2007, 07:06 PM
|
|||
|
|||
|
Can you zip and attach a copy of your workbook? It will make it much easier to work out what you need. Remember to replace any confidential info before zipping.
__________________
Trish in Oz ------------- A problem well defined is a puzzle half solved 
|
|
#4
11-02-2007, 07:05 PM
|
|||
|
|||
|
You should find som info on how to get started with Pivot tables. I had been working with Excel for many years before i one day desided to try a pivot table for analysing 30.000 rows of data I wondered what to do with. It was very easy, and after 10 minutes of lurking around with this I was speachless. This is a powerful tool
 .To make your data ready for pivot i had to reorganise the Award info by adding a new column. From there it took about 3 minutes to make the table in sheet2. You can try it out, and try to drag the fields around to make another look in just seconds. I remember learning something about Pivot Tables in school, over 10 years ago. But the example in school was only with a few datarows about selling some bananas and other fruits that didn't interested me. I tought cool, but what do i need this for? This I can do easily without a "Pivot Whizard". And I was right. But when the fruit company example with 8 sales transaction was changed to a real business database with 30.000 transactions some years later I realised that Pivot tables are realy cool, and saved me many days of work. Your report is a good example of a case where you can use Pivot table.
|
|
#5
11-05-2007, 11:13 AM
|
|||
|
|||
|
The pivot tables are a great tool, but it can not do what I want it too. Im not looking for charts, just need everything transfered into numbers. Pivot tables, wants to make everything a chart. The Sheet 2 of the attachment, is the way the Regulation has it, so it;s the way we have to put it.
 Thanks tho. Would have been great if I couldve done it that way.
|
|
#6
11-05-2007, 02:50 PM
|
|||
|
|||
Thanks
I actually found the answer to my own question.
I forgot all about sumproduct, made it so much easier. Just incase there is someone else out there with same problem. Answer I used and it works great: (Remember this is coming from another sheet) =SUMPRODUCT(--(Awards!C3:C5000="E1"),--(Awards!H3:H5000="RET"),--(Awards!I3:I5000="LOM")) If on the same sheet: =SUMPRODUCT(--(C3:C5000="E1"),--(H3:H5000="RET"),--(I3:I5000="LOM")) Thanks to all who tried to help. 
|
|
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
