Thread: Formula assistance

I am still a little new to excel but adapt at coding. My issue I have an excel database as follows

columns are

Product Type
Customer ID
Red
Blue
Yellow

it is setup so that we are selling flowers the value for several flowwers under product type would be tulip or rose then we have an ID # for the each order which is the Customer ID which is a Unique ID so therefore there could be several orders for roses say 5 orders each with its own Customer. Then each customer orders a specific number of each color.

Now that you kind of have an idea what the setup is I am trying to write a formula that will sum the number of red roses within the whole sheet on to a seperate sheet for inventory purposes so it needs to add together all the red flowers that have a product ID of rose and using a similar principle i need to count the number of customers that order Red Roses.

This main issue is the order sheet gets sorted by different fields alot so we need a way to dynamicaly sum and count based on a unique field or array.

This is a crude example i tried to simplify it as much as possible.

any assistance with this would be appriciated thanks

Originally Posted by royUK

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

right bite me! thats the most retard **** i have ever heard