Sum Range 1 when the elements in Range 2 are found in Range 3

  • Thread starter Thread starter james s shoenfelt
  • Start date Start date
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?
 
If I understand you all you need is
=counta(a3:a333)
where the fruits are in column A. Adjust to suit
 
Back
Top