I've (more or less) found a way to count some data for our monthly reports, but i am stuck when the formula needs to exclude certain lines of data when an order is cancelled.
The attached example contains a simplified sample of the report and the type of folrmula's we are using.
basically, there are 3 things i need my re[port to do:
1. calculate how many "PS" or "PE" orders (column A), are processed for cusomer "B" (column B), excluding the "PS" or "PE" cancelled orders (column D)
2. calculate how many "PS" or "PE" orders (column A), are marked with expedite "Yes" (column C), excluding the "PS" or "PE" cancelled orders (column D)
3. calculate how many orders were processed within 2 days, excluding the cancelled orders (column D)
now, the formula's are listed on the summary tab of the attached sheet, in column B.
As stated, the formula's are finished, except for the part to deduct the lines that are marked wiht Cancelled in column D.
I am also wondering if the way i built the formula can be shortened. i have now just plussed 2x COUNTIF formula's, but can this be done in another way?
For example, is there a way to include some type of "or" statement.
Thanks....
Bookmarks