Writing Function using Sumifs

I have a workbook that has a stock symbol in column A, the number of shares in column B, account name in column C, a date in column D and an action (Buy, Sell, etc.). I want to create a function using sumifs that will calulate the number of shares bought, sold, etc., during different date ranges, by account and symbol but keep getting error messages. The raw data is on a seperate sheet from the sheet I need to make the calulations on.

Any ideas?


One thought on “Writing Function using Sumifs

  1. Excel Geek


    Can you post the sumif formula you have already written that you are getting error messages with.


Leave a Reply

Your email address will not be published. Required fields are marked *