G
Guest
Hi,
I need a little help. Below is a report that I dump in Excel. You will
note that both classifications have an ‘other’ option. How do I write a
formula that will skip classification if I want the total number of File
Breakdown ‘other’ and vise versa.
I have been using a vlookup.
Thanks
Classification Breakdown
Product Information 89
Issues 69
Return Information 38
Other 30
Order Status 24
Shipping Information 9
Website 2
Payment/Billing 2
File Breakdown
Deleted 220
Vendors 4
Mailing Responses 3
Other 1
Spam 1
Wholesale 1
I need a little help. Below is a report that I dump in Excel. You will
note that both classifications have an ‘other’ option. How do I write a
formula that will skip classification if I want the total number of File
Breakdown ‘other’ and vise versa.
I have been using a vlookup.
Thanks
Classification Breakdown
Product Information 89
Issues 69
Return Information 38
Other 30
Order Status 24
Shipping Information 9
Website 2
Payment/Billing 2
File Breakdown
Deleted 220
Vendors 4
Mailing Responses 3
Other 1
Spam 1
Wholesale 1