| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
array formulas-sumproduct and average
Hello, I need hel. I am using this formula
=SUMPRODUCT(--(E2:E289=1),--(AVERAGE (H2:H289))) I don't know what's wrong with it. I need to find the average for column H in relation to 1(under 2 yrs) in Column E. Hope this makes sense. Thanks, Becky |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct, By Quarters and Amount | Excel Worksheet Functions | |||
Threaded Mode
