Search results

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:

Use countifs =countifs(a1:a500,">=25000"',"<=34999.99")