Thanks:  0
Likes:  0

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

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

2. 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?

3. 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

4. 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.

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•