Count filtered items

[bad in excel]

Hello everyone,
I'm really not sure if you will understand my question or not becuase it is very hard to explain, but I'll give it a shot.

We are making products which has two parts, PART A & PART B. If both the Parts are purchased by the same individual we take it as one product and allocate a unique ID (Product ID) given to that product. So if Mr. A buys both the parts, we will say

Product ID - Part
1 - A
1 - B

If a customer busy one part only we still take it as a product and note which part of the product has been purchased. Say Mr. B buys Part B only, we will say.

Product ID - Part
2 - A

And then all the products & Parts are borken into Phases.

Based on the conept, I would like to have help in developing a formula for:
E5 to E8
I5 to I8
K5 to K8
M5 to M8
O5 to O8

I've attached the table in the .doc format when its taken in excell the table is perfectly placed. Thank you for your help, in advance.

[corinereyes]

Hello,

Maybe it will be better if you'll attach an excel file and the expected results in their corresponding cell.

[bad in excel]

: ) sorry, didnt occur to me that I can change it in .zip and post it.

[corinereyes]

Hello,

In cell E5 try this formula:

Please Login or Register  to view this content.

select E5, press F2, then press CTRL+SHIFT+ENTER (formula in array)
then copy down up to E8.

In cell F5:

Please Login or Register  to view this content.

copy down up to cell F8
Use the sum function for cell E9 and F9.

ok, here is my query, for the ranges:
I5 to I8
K5 to K8
M5 to M8
O5 to O8

would you like to count the total of each of the criteria in D5:D8 with matching PART Bs???? Can you explain this part a bit more because i've noticed that there are 4 sets of Part A and B.

See the attached file.

[bad in excel]

Hey corinereyes
First of all, big time thank you for helping me out : ) and putting so much effort in it.

In the attachement you will find that Process A for Product 1, 2 & 12 has been completed and the summary report shows it. I need the count in the summary report.
I would also like to know if there is any possibility this count changes as and when we put on the filters. Somthing like the subtotal but it keeps the count in the next to thier phases and everything.

Once again, thank you very much for helping me out. I really, really, really appreciate : )

[corinereyes]

Hi,

See the attached file.

Where did you get the 4 in cell I7? if i'm right it should be just 2 right? i think you can go from here.

[bad in excel]

oh oh! :$
sorry, I sort of had s'th totally differnt in mind and labeled the summary report columns incorrectly. Can you please take a look at the attachment, please. thank you.

One thing more, the SUMPRODUCT, it doesnt chage the count like SUBTOTAL does it? I mean I want the numbers in summary report changing with if we put on the filters.

Thankyou very much for helping out, really grateful.

Hope you are having good holidays.

[corinereyes]

Hi,

Opps! i didn't understand your question..let me give it a try.

See the attached file, i completed the formula in the summary report.

[bad in excel]

Marry x-mass Corine

Please see the attchemnt, I've corrected the figues and the lables. I hope this is more understandable now. Thank you

[corinereyes]

Hello,

Merry xmas to you too!

Can you explain a bit more on how you counted those parts/products? I' am a little confused now.

For your filter query, what columns/criteria are you going to filter? Say, count the total of phase/product for a certain criteria?

[bad in excel]

corine, I really have started feeling ashamed that you are puting in this much effort and I still have not been able to make you understand : ). Lets give it a final try.

E5:8 Shows the Total Products to be manufactured
F5:8 Shows the Total Parts to be manufactured.

Like wise, on every processes when actual dates are entered I want to see int eh summary how much work has been done. For instance in the attached sheet, you will see:
Process 1:
H5:8 - Shows for how many products, process 1 has been completed
I5:8 - Shows for how many parts, process 1 has been completed.

Like wise it will continue. Any better? :$

[corinereyes]

Hello,

Ok. Try the attached sheet.