Thread: Formula Needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Formula Needed

I have two worksheets named "Business" and "Information"
In "Business" there are three columns.
Column A has dates in dd/mm/yy format going through to 2020.
Column B has descriptions such as hotel, petrol, expenses etc.
Column C has the price for the item.

On the "Information" worksheet I would like to pull the details from the
"Business" worksheet so that I can get a price for example on "hotel" in
column B between two dates in comlumn A with a total on the price in column
C. The dates from column A need to be specific to the month and year.

Many thanks in advance for all your help.

Mark