Hi y’all,
i admit i am not the greatest on excel, so hopefuly this will be a quick answer.
I have a spreadsheet with about 500 lines in it, what i want todo is have some ‘totals’ at the bottom, number i did easily, but there is one where it has 5 different options, and i want to display the quanity of each option in a field at the botom of the page. What type of formula should i use?:newmon:
Probably an IF statement? something like =IF(this=that,put in a 1,else leave blank), then a COUNTIF to count the number of ones. Really need a bit more info to work with this.
Probably a SUMIF(…). Type sumif into the help screen for syntax.
=SUMIF(B1:B500,“Chair”,C1:C500) will sum the quantity of chairs.
Fantastic Balrog - Exactly what i needed! Thank you! 
You’re welcome. Careful copying the formula down the 5 times the ranges will change. Either hand correct after copying or best to put a $ into the range to stop it happening in the first place ie =SUMIF(B$1:B$500,“Chair”,C$1:C$500)
Ok i finally got around to trying this but the SUMIF doesn’t seem to be doing what i want it todo. Bassicly i have a big list, and i want to cout all the ‘6.02.01.47’ in E1:E500 and give a total, then i want to in the next box count all the ‘612’ in E1:E500 and give a total, and the next box i want to count all the ‘6.02.01.56AJ’ and give a total, and in the next box i want to count all the ‘6.02.01.56BB’ and give a total, i know that the sumif should work, but i keep on getting strange number each time, what i have written is;
=SUMIF(E2:E453,612) <-- which gives me 55692, when its more like 150
=SUMIF(E2:E453,“612”) <— gives me 0
=SUMIF(E4:E455,“6.02.01.47”) <— gives me 0
=SUMIF(E4:E455,6.02.01.47) <---- gives me a error
I know now that i should have paid more attention in gcse IT 
Thanks for any help!
SUMIF will add up numbers, but 6.02.01.47 is text even though it contains numbers. If you use COUNTIF (e.g. =COUNTIF(E2:E455,"=6.02.01.47") ) this will count all the instances it finds of 6.02.01.47. Same with 612, but use =COUNTIF(E2:E453,"=612").
Perfect, THanks!
Glad I could help m8! 
yes,great job,thanks.
Hi,
I have a column of birth dates. (Column V) I want to add another column beside it (Column U) which shows the age in years. In U1 I placed todays date. I need a formula in (let’s say) U3 that compares U1 to V3 and displayes the age in years. Both columns are Cell Formated in [DATE 14-Mar-98] format.
Thank You,
Al
Try =YEARFRAC(V2,$U$1,1) in U2 and copy down the column.
I couldn’t get that to work under Excel 2000, but the following worked in the column to the right of the birth dates and formatted as fractions:
=(TODAY()-V1)/365
You also don’t need the column with today’s date in it either.
Or do you divide by 365.25?
Nah! Leap years just confuse the issue 