Home |
Search |
Today's Posts |
#1
|
|||
|
|||
average if zero
I'm looking for a formula similar to the following, but one that works.
=average(if((A1:A4="Jones")+(C1:C4"0"),C1:C4)) Column A represent sales rep column, and I want to see the average sales for all cells that have data entered in column C. I've tried the ctrl+shift+enter, but it's still averaging with zeros, so something is wrong with my formula. Thank you. -- Lori |
#2
|
|||
|
|||
Lori,
=AVERAGE(IF((A1:A4="Jones")*(C1:C40),C1:C4)) Array entered with Ctrl-Shift-Enter. HTH, Bernie MS Excel MVP "Lori Hornick" wrote in message ... I'm looking for a formula similar to the following, but one that works. =average(if((A1:A4="Jones")+(C1:C4"0"),C1:C4)) Column A represent sales rep column, and I want to see the average sales for all cells that have data entered in column C. I've tried the ctrl+shift+enter, but it's still averaging with zeros, so something is wrong with my formula. Thank you. -- Lori |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
AVERAGE problems | Excel Worksheet Functions | |||
how do I get AVERAGE to ingore a zero value cell | Excel Worksheet Functions | |||
how do I get AVERAGE to ingore a zero value cell | Excel Worksheet Functions | |||
average, array and offsets | Excel Worksheet Functions |