tallying up items in an inventory

[muya]

I have a spreadsheet of my inventory that is broken down into individual account. I need to tally up how many desktops and how many laptops each account has. Any help is appreciated.

 

[Russ At Index]

Hi Muya

Have you considered using a pivot table
to display your results ????

Hope this helps

Russ.

 

[muya]

Hi Muya

Have you considered using a pivot table
to display your results ????

Hope this helps

Russ.

No I have'nt. I don't really know what a pivot table does.

 

[Russ At Index]

Hi Muya,

Have a look at the Help function searching for
"Pivot Table".

It has a feature tutorial that gives you an
overveiw of what a pivot table can report !!!!!!

It is a very useful inventory application !!!!!!!

Russ.

 

[rs2k]

ADVERTISEMENT

SUMIF can also do it.

Colin

 

[muya]

SUMIF can also do it.

Colin

I've tried this and i know it should work. but i can't get past specifying the range it needs to look at.

i have this: =SUMIF(DESKTOPS!B7:B705,1000)

where 1000 is the account number(criteria).

 

[rs2k]

In the example, in F2 copied down;
=SUMIF(A2:A6,E2,B2:B6)
in G2 copied down;
=SUMIF(A2:A6,E2,C2:C6)

Book1
	A	B	C	D	E	F	G	H
1	Account	dt	lt			dt	lt
2	a	2	1		a	7	6
3	b	3	3		b	3	3
4	c	4	2		c	4	2
5	a	5	5		d	0	0
6	e	1	7		e	1	7
7
8
Sheet1

HTH
Colin.