Sorry I meant the formula to read
=countif(a1:a500,">=25000")-countif(a1:a500,">=34999.99")
With this I am assuming that your salary data is contained within range a1:a500
The ABC are the column headings
It could be a couple of things...
Is your salary data formatted as text? If so change it to number
Are u using an old version of excel? If so then change the formula to...
=count(a1:a500,">=25000")-countif(a1:a500,">=34999.99")
Obviously try and use the ranges as SS suggests above if you feel...
Yeah this and then to be extra fancy use sumifs along the same lines to give you the total values of those in that range!
And stick some fancy borders and shadings on to make it look good! :lol:
This plus The Unicorn next door both decent pubs and on a 'sort-of' route from the station to the ground (going thru UCL territory). The Old Vic just opposite the station on Fishergate and the Old Black Bull on Friargate would make nice stop-offs too
I tend not to answer 0843 numbers and when I do get the occasional ambulance chaser on a 01 number the first thing I do is block the number from future contact