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

  • Thread starter james s shoenfelt
  • 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?
 
D

Don Guillett

If I understand you all you need is
=counta(a3:a333)
where the fruits are in column A. Adjust to suit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top