Count formula within a named range.

P

PW11111

Hi,

How do I change the following formula

=SUMIF($F$39:$F$79,"PW Shopfitters",$D$39:$D$79)/COUNTIF($F$39:$F$79,"PW
Shopfitters")

to count within a named range (PW Shopfitters).

Any help would be great.

Cheers,

Phil
 
K

Kassie

Hi

A range name cannot have spaces, maybe that's your problem. Name your range
PW_Shopfitters. Then replace your cell references with PW_Shopfitters, eg
=Sumif(PW_Shopfitters,"PW Shopfitters",............
 
P

PW11111

Thats great.

Thank-You.

Kassie said:
Hi

A range name cannot have spaces, maybe that's your problem. Name your range
PW_Shopfitters. Then replace your cell references with PW_Shopfitters, eg
=Sumif(PW_Shopfitters,"PW Shopfitters",............
Click to expand...
 
Top