If statements

  • Thread starter Thread starter Brad1982
  • Start date Start date
B

Brad1982

I am rather new to if statements so I will explain my problem i
words...

I am making a backorder spreadsheet in excel to compare backorders pe
company,SKU, and reason backordered.

My data looks something like this
Company ...............SKU.......................Backorder reason
ABC Co.................Red Paint........................ran out
ABC Co.................Blue Paint.......................wrong color
Some Co................Blue Paint......................ran out
Some Co.............Yellow Paint................... ran out

My end result needs to compare The SKU to the company and then to th
backorder reason to answer these questions..

How many times was red paint backordered to ABC co.?

How many times was red paint backordered with a reason ran out?

I am so lost :
 
Back
Top