Using SUM, SUMIF, COUNT, COUNTIF, COUNTIFS, COUNTBLANK and COUNTA functions in Excel and Google Sheets

	A	B	C	D	E	F
1	1	2	a
2	b		d
3	3	4	5
4		HTTPS://STUDYBLAST.BLOGSPOT.COM
5		YOUTUBE: ZASOFT PK
6				Function	Syntax	Result
7				SUM	=SUM(A1:C3)	15
8				Blank	=COUNTBLANK(A1:C3)	1
9				Numbers	=COUNT(A1:C3)	5
10				Data	=COUNTA(A1:C3)	8
11				CountIFS	=COUNTIFS(A1:A3,"b",(C1:C3),"d")	1
12				SUMIF	=SUMIF(A1:C3, "=>2")	14

Referring to Table given above:

SUM FUNTION

SUM is probably the most used MS-Excel predefined function. It is used to add all the numbers in selected range of cells. 

Syntax: =SUM(Range of Cells)

Example: Look at Cell E7 and F7. In E7 Range A1:C3 means that all numbers should be added, which are present in this range. The result is given in F7 i.e, 15. Now if we check it 

A1=1, B1 = 2, C1 = a (not a number), A2 = b(not a number), B2 = Empty, C2 = d (not a number), A3 = 3, B3 = 4, C3 = 5

So the numbers are 1, 2, 3, 4 and five. If we manually add them up:

1+2+3+4+5= 15

The same answer is obtained through using =SUM(A1:C3) function.

KEEP in TOUCH and subscribe for updates