ChristopherPaul
Puritan Board Senior
Anyone here know the best way to nest multiple SUMIF formulas?
I need to sum only those cells that fall within a date range AND if they meet a code requirement within that conditional date range.
So far I can SUMIF the date range and SUMIF the code requirement, but not SUM the code requirement within the specified range.
I can accomplish my purposes with a pivot table for the time being, but ultimately I would like to create a formula to fit nice and neat within a summary sheet.
I need to sum only those cells that fall within a date range AND if they meet a code requirement within that conditional date range.
So far I can SUMIF the date range and SUMIF the code requirement, but not SUM the code requirement within the specified range.
I can accomplish my purposes with a pivot table for the time being, but ultimately I would like to create a formula to fit nice and neat within a summary sheet.