Hi...Very much learning!!

I have a spreadsheet that needs three parts sorted - xl 2003

Q!: In column A I have a location say Exeter....in column D I have a type of
Benefit say JSA - how can i write a formula so that on Sheet 2, I can count
how many customers in Exeter are claiming JSA based on where they are,
according to the benefit claimed....i suspect COUNTIF, but dont know how to
link it all together.

Q2: In column E, I have a date a referral was made....I want to use a
Green, Amber, Red, CF method, so that if date entered is up to 7 days from
the date entered (not TODAY as it wont always be that) the cell goes green -
I am using: =IF(E3<"",E3TODAY()-7), for Amber: =AND(E3<"",E3TODAY()-14)
and Red: =AND(E3<"",E3TODAY()-600)...the date needs to be updating so will
go from Green to Amber to Red as the CF applie - I know the formulas are
wrong but bin searching dicussion groups/net forr ages.

Q3: I would like to further develop this CF so that the colour can be
entered into column F as text i.e. Green, Amber or Red so that I can use a
simple COUNTIF, which I can do from that column.

Apologies for this long thread....tried asking the 'experts' in work, but
alas, their knowledge it would seem is best kept for them, just got 'do this'
and am now floundering !!! any help greatly appreciated and will add to my
kowledge so IT section can give the normal response....switch off / switch
off...sorry peeved with them

Thanks

Craig