Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Counting Rows with Conditions Met 2

Status
Not open for further replies.

akloster2

Technical User
Nov 16, 2001
30
US
Okay, I've been working on this long enough. I need help PLEASE.

Location A has a widget1
Location A has a widget2
Location B has a widget2
Location B has a widget1
Location C has a widget4
Location A has a widget2
Location B has a widget1
Location C has a widget4

So, I want to set up a matrix to count how many of which widgets are in what locations:

widget1 widget2 widget4
Location A 1 2
Location B 2 1
Location C 2

So, what's my formula? I've been trying nested IF, COUNTIF, AND, Array formula, nothing seems to work :(

Thanks,
 
Here is an example of the pivot table I created with your data:
Location Widget
a 1
a 2
b 2
b 1
c 4
a 2
b 1
c 4


Count of Widget Widget
Location 1 2 4 Grand Total
a 1 2 3
b 2 1 3
c 2 2
Gnd Total 3 3 2 8


Hope the spacing isn't too hard to read.
AngO
 
I agree,,,the pivot table is the perfect tool for this!
and a star for AngO
 
Thank You ETID.
Hope you're having a nice weekend.
AngO
 
Thanks Ang0. That was just what I was looking for. I had heard of Pivot Tables, but hadn't ever tried one before. I just applied it to my problem, and it worked perfectly. Star on the way!

akloster2
 
akloster2,
Glad I could help. Hope you are having a nice weekend also!
AngO
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top