I want to calculate the same. In our progress report Excavation related to cement colour. I want to How many foundations done. I want to calculate in excel. Kindly clarify me.
2006-12-15 16:14:35 · 2 answers · asked by YSSP 1 in Computers & Internet ➔ Software
The clarification that is needed is your question.
Sounds like you need help figuring how to write a formula in Excel, but I'm not clear on what you want to end up with.
2006-12-15 16:18:00 · answer #1 · answered by Stuart 7 · 0⤊ 0⤋
I am having a little trouble understanding your question, but I think you want to use a pivot table. I just made a quick sheet with the following: 2 columns with headings Job and color. Put some text in the job column for 5 jobs. Assign each job a color in the color column. Make sure you use the same spelling or code for each different color. Use one color 2 or 3 times. Then highlight the entire section and goto data / pivot table. Answer a few wizard questions. Next, you will have to drag the job field into "drop data items here" and color field into "drop row fields here". Next, tell it what you want it to do with the color field. Click the top left field which should say "sum of job" then find the pivot table toolbar. Click field settings and tell it to count. Voila! Experiment with a little sheet like this then make a backup copy of your spreadsheet while you do the same with your real data. Good Luck!
2006-12-16 00:36:48 · answer #2 · answered by PMSumter 1 · 0⤊ 0⤋