Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with complicated formula
I have this formula but it is not giving me the results I am
expecting: =SUMPRODUCT((A12:I350="Pleasanton")*(AVERAGE(I12:I 350)+(AVERAGE (J12:J350))))/2 I am trying to average the sum of 2 columns I & J where "Pleasanton" is in the row. I cannot use the AverageIF formula due to some limitations on another program I will be exporting the spreadsheet into. Due to the large arrays I am working with I am not sure what other method I can use if I can't use averageif. Are there any workarounds? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complicated formula | Excel Worksheet Functions | |||
I have a complicated formula that I need SERIOUS help with please! | Excel Discussion (Misc queries) | |||
Complicated Formula - I think | Excel Worksheet Functions | |||
Complicated formula | Excel Worksheet Functions | |||
Complicated Formula | Excel Discussion (Misc queries) |