| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average
Here's my formula:
=AVERAGE(IF(MoTotals!$F$17:$F$280,MoTotals!$F$17: $F$28)) Now I want to add in this formula And If cell < A21 Just not sure how to put andif Thanks in advance. |
|
#2
|
|||
|
|||
|
Average
Do you just want to do the average if and only if a certain cell value is
equal to the value in A21? If so, then =IF(B21=A21,AVERAGE(IF(MOTotals!$F$17:$F$280,MOTo tals!$F$17:$F$28)),"") as an array formula -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jh3016" wrote in message ... Here's my formula: =AVERAGE(IF(MoTotals!$F$17:$F$280,MoTotals!$F$17: $F$28)) Now I want to add in this formula And If cell < A21 Just not sure how to put andif Thanks in advance. |
|
#3
|
|||
|
|||
|
Average
Sorry, what I want: if B21 not equal to "4/1/2005", then calculate the rest
of the formula. "Bob Phillips" wrote: Do you just want to do the average if and only if a certain cell value is equal to the value in A21? If so, then =IF(B21=A21,AVERAGE(IF(MOTotals!$F$17:$F$280,MOTo tals!$F$17:$F$28)),"") as an array formula -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jh3016" wrote in message ... Here's my formula: =AVERAGE(IF(MoTotals!$F$17:$F$280,MoTotals!$F$17: $F$28)) Now I want to add in this formula And If cell < A21 Just not sure how to put andif Thanks in advance. |
|
#4
|
|||
|
|||
|
Average
=IF(B21<--"2005-04-01",,AVERAGE(IF(MOTotals!$F$17:$F$280,MOTotals!$F $17:$F
$28)),"") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jh3016" wrote in message ... Sorry, what I want: if B21 not equal to "4/1/2005", then calculate the rest of the formula. "Bob Phillips" wrote: Do you just want to do the average if and only if a certain cell value is equal to the value in A21? If so, then =IF(B21=A21,AVERAGE(IF(MOTotals!$F$17:$F$280,MOTo tals!$F$17:$F$28)),"") as an array formula -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jh3016" wrote in message ... Here's my formula: =AVERAGE(IF(MoTotals!$F$17:$F$280,MoTotals!$F$17: $F$28)) Now I want to add in this formula And If cell < A21 Just not sure how to put andif Thanks in advance. |
|
#5
|
|||
|
|||
|
Average
=AVERAGE(IF(AND(MoTotals!$F$17:$F$280,B21<"4/1/2005"),MoTotals!$F$17:$F$28))
This should work as well. "jh3016" wrote: Sorry, what I want: if B21 not equal to "4/1/2005", then calculate the rest of the formula. "Bob Phillips" wrote: Do you just want to do the average if and only if a certain cell value is equal to the value in A21? If so, then =IF(B21=A21,AVERAGE(IF(MOTotals!$F$17:$F$280,MOTo tals!$F$17:$F$28)),"") as an array formula -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jh3016" wrote in message ... Here's my formula: =AVERAGE(IF(MoTotals!$F$17:$F$280,MoTotals!$F$17: $F$28)) Now I want to add in this formula And If cell < A21 Just not sure how to put andif Thanks in advance. |
|
#6
|
|||
|
|||
|
Average
This only returns 0.00%, which is not right. Does this being a date make a
difference? Is there a DATE function that needs to be used? "Sloth" wrote: =AVERAGE(IF(AND(MoTotals!$F$17:$F$280,B21<"4/1/2005"),MoTotals!$F$17:$F$28)) This should work as well. "jh3016" wrote: Sorry, what I want: if B21 not equal to "4/1/2005", then calculate the rest of the formula. "Bob Phillips" wrote: Do you just want to do the average if and only if a certain cell value is equal to the value in A21? If so, then =IF(B21=A21,AVERAGE(IF(MOTotals!$F$17:$F$280,MOTo tals!$F$17:$F$28)),"") as an array formula -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jh3016" wrote in message ... Here's my formula: =AVERAGE(IF(MoTotals!$F$17:$F$280,MoTotals!$F$17: $F$28)) Now I want to add in this formula And If cell < A21 Just not sure how to put andif Thanks in advance. |
|
#7
|
|||
|
|||
|
Average
maybe...
=AVERAGE(IF(AND(MoTotals!$F$17:$F$280,B21<date(2 005,4,1)), MoTotals!$F$17:$F$28)) (still all one cell and still array entered) jh3016 wrote: This only returns 0.00%, which is not right. Does this being a date make a difference? Is there a DATE function that needs to be used? "Sloth" wrote: =AVERAGE(IF(AND(MoTotals!$F$17:$F$280,B21<"4/1/2005"),MoTotals!$F$17:$F$28)) This should work as well. "jh3016" wrote: Sorry, what I want: if B21 not equal to "4/1/2005", then calculate the rest of the formula. "Bob Phillips" wrote: Do you just want to do the average if and only if a certain cell value is equal to the value in A21? If so, then =IF(B21=A21,AVERAGE(IF(MOTotals!$F$17:$F$280,MOTo tals!$F$17:$F$28)),"") as an array formula -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jh3016" wrote in message ... Here's my formula: =AVERAGE(IF(MoTotals!$F$17:$F$280,MoTotals!$F$17: $F$28)) Now I want to add in this formula And If cell < A21 Just not sure how to put andif Thanks in advance. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| plotted Average | Charts and Charting in Excel | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
Linear Mode
