gskelton

Hi, How about: from C1, =SUMIF($A$1:$A$10,A1,$B$1:$B$10) and copy down? (Drag) Gaz

Hi, If your data is in A1 - B8, then put the following formula in C1 and drag down to C8: {=SUM(($A$1:$A$8=A1)*($B$1:$B$8="x"))} this is an array formula - use Ctrl Shift Enter to put the curly brackets in Regards Gary

Hi there, How about this: COUNTIF provides for one criteria. If we count column A, where vehicle type is Cars: =COUNTIF(A2:A10,”Cars”) But what if we want to count of records where vehicle type is cars and the color is black? We cannot use the COUNTIF function for multiple criteria. We need to use an array formula, which requires that we press Ctrl+Shift+Enter after typing it, instead of just Enter. =SUM((A2:A10=”Cars”)*(B2:B10=”Black”)) Count of records with between 500 and 800 units sold. This also requires an array formula, press Ctrl+Shift+Enter after typing it. =SUM((C2:C10>=500)*(C2:C10<=800)) Because these formulas are Array Formulas (sometimes referred to as CSE formulas because we must Ctrl+Shift+Enter to enter them), they look a little different. In the formula bar, after it's been properly entered, the above formula looks like this. {=SUM((C2:C10>=500)*(C2:C10<=800)) } Can't remember where I got this tip, but kudos to them... Gary

Housemartins... http://z.about.com/d/gohawaii/1/0/N/K/4/poipu_beach_park_001.jpg

Hi, I agree with all the 'It's new, great, and once you get used to it, you'll like it' brigade. However, Productivity goes down if someone (Micro$oft) takes away something as standard across most software packages as the File... etc menu. Did my head in, that's for sure. Many years of getting to know where everything is only to have it ALL snatched away from you is hard to swallow. Even Media Player has a 'Clasic Menu' option... Gaz

Hi, We have an interesting situation at our school. The head wanted to move all years up one in June (Y9 - Y10 etc). The people here created a new dataset, timetable etc etc for the change. However, we have fallen foul of rules regarding attendance data, because the data ends at the end of may and starts again in June. They are insisting on reports for the complete school yar (Sept - July) for legal attendance issues. Is there a way of merging the two datasets (for attendance only) so we can report on full (standard) academic year attendance using CMIS? Or perhaps reporting across two datasets? I'd appreciate any pointers anyone can give. Regards Gary

Hi, My Name's Gary and although I've been in IT all my working life, this is my first time working in education. Term time plus 10 is where I'm at - woo hoo! very new to me!

Hi, I'm new to eduction. I've worked in IT in business all my life so far. We have CMIS at our school. It seems very complex to me. I'd at least like to have a look at a data dictionary for the system so I'd be able to find out where data resides on the system. Does anyone know where I could get my hands on such a nugget of informaion??

Hi, I'm new to both education and CMIS. I have a problem that I hope someone can help with. We have changed our school year so that it now runs from June to End of May. However, we are legally required to produce attendace reports from September to September. Is there any way of using two datasets to report from CMIS. Or is there any way to transfer our June/July attendance records back to the previous year's dataset?? Thanks in advance Gary from Kent