| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells based on date range in another column | New Users to Excel | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Linear Mode
