ExcelBanter - Count formula within a named range.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count formula within a named range. (https://www.excelbanter.com/excel-discussion-misc-queries/35958-count-formula-within-named-range.html)

PW11111

Count formula within a named range.

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

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",............
--
ve_2nd_at. Randburg, Gauteng, South Africa

"PW11111" wrote:

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

PW11111

Thats great.

Thank-You.

"Kassie" wrote:

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",............
--
ve_2nd_at. Randburg, Gauteng, South Africa

"PW11111" wrote:

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

All times are GMT +1. The time now is 07:01 PM.