I have a Regional Sales Report, with Column A (Name of Product - text field), and Colum B (Sale Status - text field). I, also, have a Regional Summary Report with Column C (Sale Disposition)
I am trying to write a formula that determines whether Regional Sales Report Column A is 'ACME"; If yes, then check Regional Sales Report Column B ('ACME lines), for 'Sold'; Count number of 'Sold' lines; Auto-populate sum sold in Regional Summary Report Column C, on the line that represents regiona sales for 'ACME'.