Help,

M

Muppet

Looking for a bit of a tip if anyone can help please..

I want to say,

if anything between such and such cells should be equal to such an
such value, then count it as 1

I thought I would be able to get it working with

=Countif(criteria, "range") equals 1

but that didnt work...

any ideas please??
 
A

Andy B

Hi

Here's an example of a COUNTIF:
=COUNTIF(A4:A12,2)
This counts the range A4:A12 and if any of the values are 2, then they are
counted. So if the range was 1,2,3,4,2,4,3,2,1 the result would be 3 - as
there are 3 2s in the range.
 
J

Joey

Hey

Did you try it with the criteria and range around the other way.

=Countif(Range,"criteria")

This will count the amount of times the data you're looking for appear
in your range

Hope this helps

Cheers
Joe
 
M

Muppet

thats works for 1 variable.

say i have a lits that goes,

apples
apples
berries
tomatoes

and i have a box somewhere to add it up in.

Now... i want it to only add up apples and berries, so the total woul
be 3.

I thought this could be done with

=COUNTIF(E4:E10,"apples","berries")

But this doesnt work.... any ideas
 
A

Andy B

Hi

Just use 2 COUNTIFs added together:
=COUNTIF(E4:E10,"apples")+COUNTIF(E4:E10,"berries")
 
Top