I have a Table with dates in column A and then column B there is a dollar amount. Column C and D have drop down categories and subcategories. I know how to add up the columns/rows, based on the category chosen. But now I need to add a date factor to my equation. So posted below is my current formula. But I need it to only pull the numbers from the rows with dates before July 1st 2016 and or after July 1st 2016.
=SUMIF(Payrollregister[Subcatagory],'Fixed Data'!Q3,Payrollregister[Withdrawal])+SUMIF(FixedExpenses[Subcatagory],'Fixed Data'!Q3,FixedExpenses[Withdrawal])+SUMIF(COB[Subcatagory],'Fixed Data'!Q3,COB[Withdrawal])
Thank you for any help!
Brenda
Bookmarks