Let's say "A1#" refers to an array with four rows: "Apple", "Banana", "Orange","Peach".
And let's say you want to check each row/cell to see if it is either "Banana" or "Peach".
The formula "=IF(A1#={"Banana","Peach"},1,0)" produces a 2x4 array, instead of the desired 1x4 column, so I thought maybe the solution would be "=SUM(IF(A1#={"Banana","Peach"},1,0))", but this sums up the entire array, instead of summing up each row, resulting in a single 1x1 cell.
How do I do this so that I checks each row, producing the desired 1x4 array? (Obviously, this could easily be done without an array by copying and pasting a formula for each cell, but I'd like to accomplish this as an array.)
Thanks!
And let's say you want to check each row/cell to see if it is either "Banana" or "Peach".
The formula "=IF(A1#={"Banana","Peach"},1,0)" produces a 2x4 array, instead of the desired 1x4 column, so I thought maybe the solution would be "=SUM(IF(A1#={"Banana","Peach"},1,0))", but this sums up the entire array, instead of summing up each row, resulting in a single 1x1 cell.
How do I do this so that I checks each row, producing the desired 1x4 array? (Obviously, this could easily be done without an array by copying and pasting a formula for each cell, but I'd like to accomplish this as an array.)
Thanks!