Remember Me?

#1
 Junior Member Posts: 1
Mac Countif function not working at all

My countif function doesn't work at all. I have version 14.2.5 for mac (OS X) and have updated it completely but still it doesn't work. If I try to write the same formula in windows excel, then it works just fine, so it isn't the formula that has an error.

I was using the following simple example:
Data Data
apples 32
oranges 54
peaches 75
apples 86

=COUNTIF(A2:A5,"apples")

But no matter what, I always get: "The formula you typed contains an error"
on all the formula.

Do anyone know what to do?
#2
 Member Posts: 47
COUNTIF or SUMIF

If you want to count how many times "apples" pops out on the list, you have to use this formula:

=countif(A2:A5, "apples")

There you'll be able to know how many apples there are, but if you want to know the total of the 2 numbers associated with "apples", we have"

=SUMIF(A2:B5,"apple",B2:B5)

There, you will find that there are 118 apples. By the way, I learned this from this website. You can check this out to learn more about sumif: https://www.efinancialmodels.com/kno...tion-in-excel/

Hope this helps

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ub Excel Worksheet Functions 5 September 26th 07 03:39 PM c mateland Excel Worksheet Functions 3 September 3rd 07 02:46 AM CJ Excel Programming 1 January 16th 07 05:28 AM jshuatree Excel Worksheet Functions 4 July 17th 06 10:48 PM Nick Krill Excel Discussion (Misc queries) 4 June 24th 06 07:42 PM

All times are GMT +1. The time now is 01:29 PM.