Thread: extract data from sheet using a between date and match criteria to total profit
View Single Post
 
Old 04-11-2018, 01:18 AM
tj61 tj61 is offline Windows 8 Office 2007
Novice
  
Join Date: Apr 2018
Location: norfolk uk
Posts: 3
tj61 is on a distinguished road
Default extract data from sheet using a between date and match criteria to total profit
I have a large spreadsheet cost and sales of materials I want to use the delivered date column and the company column to calculate profit for the 2 companies on a monthly basis

so between delivered dates 01/01/18 and 31/01/18 company sales or ltd

extract data onto new sheet including profit column

Thanks

Trev
Attached Files
File Type: xlsx TEST DATA.xlsx (18.6 KB, 12 views)
Last edited by tj61; 04-11-2018 at 03:39 AM. Reason: added file
Reply With Quote