SUM of records

[Onjslnjps]

I'm looking for a formula that will give me the quantity of line items (records) rather than a sum of the actual currency values. Sounds simple but it's beyond my knowledge...

Thanks in advance

 

[T. Valko]

I'm looking for a formula that will give me the quantity of line items (records) rather than a sum of the actual currency values. Sounds simple but it's beyond my knowledge...

Thanks in advance

Maybe something like this...

=COUNTA(A2:A100)

That will return the count of all non-empty cells within the referenced range.

 

[snoopyhr]

Not sure I understood your concern properly, .... here is something maybe you can use to count #of transaction, transcations by product, or no. products

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	If this is your data table				*	Not sure if you want a result like this
2	Names	Product	Price	Units	*	Product	Price	# of Sales	Units
3	Name-1	Prod-1	$ * 10.00	20	*	Prod-1	$10.00	1	20
4	Name-2	Prod-2	$ * 20.00	40	*	Prod-2	$20.00	4	130
5	Name-3	Prod-3	$ * 30.00	80	*	Prod-3	$30.00	4	240
6	Name-4	Prod-4	$ * 40.00	40	*	Prod-4	$40.00	3	120
7	Name-5	Prod-2	$ * 20.00	10	*	*	*	*	*
8	Name-6	Prod-3	$ * 30.00	50	*	*	*	*	*
9	Name-3	Prod-2	$ * 20.00	30	*	*	*	*	*
10	Name-4	Prod-3	$ * 30.00	90	*	*	*	*	*
11	Name-5	Prod-4	$ * 40.00	70	*	*	*	*	*
12	Name-4	Prod-2	$ * 20.00	50	*	*	*	*	*
13	Name-5	Prod-3	$ * 30.00	20	*	*	*	*	*
14	Name-6	Prod-4	$ * 40.00	10	*	*	*	*	*
Sheet1