Re: Percentage For Entire Columns

I have some sort of solution for you, but since you don't say where you want this information to be, I've chosen a spot at random. Adjust according to your requirements.

In cell L15:

[frc]=COUNTA($H$2:$H$107)[/frc]

I've used H2 as the first row to look in as I've presumed you have a header in H1. I used H107 as the likely last row you'll need to look at, but make this bigger or smaller as required, it should be at least as big as the largest number of orders you're ever likely to get in a week. The formula should give the total number of orders for that week. (It's also used in the formulae to follow). In the cell to the left or right you could put a label such as 'Total Orders'.

In cell L16:

=COUNTIF($H$2:$H$107,"Multiple Orders")/COUNTA($H$2:$H$107)

In cell L17:

=COUNTIF($H$2:$H$107,"No Order In System")/COUNTA($H$2:$H$107)

In cell L18:

=COUNTIF($H$2:$H$107,"Credit Info Incorrect")/COUNTA($H$2:$H$107)

In cell L19:

=COUNTIF($H$2:$H$107,"Other")/COUNTA($H$2:$H$107)

Format cell L16:L17 as a Percentage.

Put labels in adjacent cells as appropriate.

p45cal

ps. I removed code tags from the later formulae as putting them in capitalised the lower case letters.