Formula Problems

Aaron · May 9th, 2002, 08:06 AM

Does anyone know why this formula will not work? Thanks for any help.

=SUMIF($C$6:$O$6,"Actual",AVERAGEA(C19:O19))

Aladin Akyurek · May 9th, 2002, 08:10 AM

Quote:

On 2002-05-09 07:06, Aaron wrote:
Does anyone know why this formula will not work? Thanks for any help.

=SUMIF($C$6:$O$6,"Actual",AVERAGEA(C19:O19))

The syntax is not good: You could maybe state what you'd like to do?

Aaron · May 9th, 2002, 08:36 AM

I have a range of cells that are %'s, and they will change every four weeks. I want to try and get the average of a certain range when the four weeks change. For instance: in range("A1:M1") are my percentages. This month I want the average of Range("A1:D1"), then next month Range("A1:E1"). Does this help any. I know my questions are really scattered brained, but I appreciate the help. -asa

Aladin Akyurek · May 10th, 2002, 05:33 AM

Aaron,

It's:

=SUMIF(C6:O6,"Actual",C19:O19)/MAX(1,COUNTIF(C6:O6,"Actual"))

where C6:O6 houses fields like "Actual" and C19:O19 corresponding percentages that you want to average depending on the field that figures as condition/criterion.

Aladin

[ This Message was edited by: Aladin Akyurek on 2002-05-10 04:34 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 08:06 AM	#1
Aaron Board Regular Join Date: Feb 2002 Location: Texas Posts: 233	Does anyone know why this formula will not work? Thanks for any help. =SUMIF($C$6:$O$6,"Actual",AVERAGEA(C19:O19))

May 9th, 2002, 08:36 AM	#3
Aaron Board Regular Join Date: Feb 2002 Location: Texas Posts: 233	I have a range of cells that are %'s, and they will change every four weeks. I want to try and get the average of a certain range when the four weeks change. For instance: in range("A1:M1") are my percentages. This month I want the average of Range("A1:D1"), then next month Range("A1:E1"). Does this help any. I know my questions are really scattered brained, but I appreciate the help. -asa

May 10th, 2002, 05:33 AM	#4
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	Aaron, It's: =SUMIF(C6:O6,"Actual",C19:O19)/MAX(1,COUNTIF(C6:O6,"Actual")) where C6:O6 houses fields like "Actual" and C19:O19 corresponding percentages that you want to average depending on the field that figures as condition/criterion. Aladin [ This Message was edited by: Aladin Akyurek on 2002-05-10 04:34 ]