Syntax

[Pilule]

I'm having problems with the syntax of a function. I want to count the number of time a number comes up, my formula would be;

=COUNTIF(A1:A50,A1<>A2). It's the A1<>A2 that I can't get to plug in correctly.

What would the SUMPRODUCT function look like to do the same thing?

Thanks

 

[Dave Patton]

An example with expected results would have been helpful.

Consider the following

Excel 2010
	A	B	C
1	12	4
2	12
3	14
4	14
5	15
6	15
7	16
1b

Cell Formulas
Range	Formula
B1	=SUMPRODUCT(--(A1:A50<>A2:A51))

 

[Pilule]

It works.

Where could I find more information on how to use SUMPRODUCT? This function doesn't seem to bee well documented.

Thanks

 

[Joe4]

Where could I find more information on how to use SUMPRODUCT? This function doesn't seem to bee well documented.

You can start here: https://exceljet.net/excel-functions/excel-sumproduct-function

There are lots of others. Just Google "Excel SUMPRODUCT uses".

 

[Scott Huish]

The SUMPRODUCT formula will have a problem if a number reoccurs later in the list.

Perhaps:
=SUM(1/COUNTIF(A1:A7,A1:A7))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.