|
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. |
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. |
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. |
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. |
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. |
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. |
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 |
| All times are GMT +1. The time now is 03:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com