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?

Thanks

One thought on “Writing Function using Sumifs

  1. Excel Geek

    Hi

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

    Thanks

Leave a Reply

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