J
james s shoenfelt
I'm familiar how the array function such as the following works:
={sum(if(fruits="apple",quantity_sold))}
But, let's say that I want to replace "apple" with a range name that
may include "apple" and "banana". But then again, you might leave it
to just say "apple". I'd like to have a formula that updates
regardless of how many fruits I put in the "fruit range".
Can you do it?
={sum(if(fruits="apple",quantity_sold))}
But, let's say that I want to replace "apple" with a range name that
may include "apple" and "banana". But then again, you might leave it
to just say "apple". I'd like to have a formula that updates
regardless of how many fruits I put in the "fruit range".
Can you do it?