| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average If Adejecent Cells Greater Than Zero
I have a have multiple worksheets that contain data i would like to calculate
some averages for. Down one column is BF, LN, DN, SCK, TOT repeated, and the adjecent cell contains a value I currently have the average for Breakfast as =(SUMIF(August!$J$2:$J$91,"BF",August!$K$2:$K$91))/COUNTIF(August!$J$2:$J$91,"BF"), howver the count function still counts cells that have zero values, I would like the average of only the non-zero cells. Any ideas???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use functions when cells are merged | Excel Worksheet Functions | |||
| Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Threaded Mode
