Help with sumif

[rbpd5015]

Ok I got a sumif question


I got a column called Assignment (B8:B121 and a column called Division(C8:C121)

I want to know the following

how many unassigned assignments I have in each division.

for example I got 50 unassigned vehicles listed in 121 rows of assignments. I then got 3 divisions ADMIN, DETECTIVE, PATROL.

I got a chart above my table and want to know how many of each Division are Wrecked and how many are unassigned.

Thanks so much

Matt

[jeffreybrown]

Hi Matt,

Have you looked into a pivot table?

If a pivot table does not work for you, how about a sample workbook?

[rbpd5015]

I will, I guess I am not experienced enough with how to create one. I will try now

[jeffreybrown]

You could maybe start here or do a google search and you're sure to get many hits.