G
Guest
I imported a set of activities from Project that I use for a Milestone Chart.
I want to use SumIf to total a separate column of data for a particular
month. For instance, I want to sum up data for only October 2007. I can't get
the formula correct using > and < in the SUmIF criteria. This is what I have
that isn't working:
=SUMIF(E:E,">10/1/2007 5:00:00 PM and <10/31/2007 5:00:00 PM",G:G)
I want to use SumIf to total a separate column of data for a particular
month. For instance, I want to sum up data for only October 2007. I can't get
the formula correct using > and < in the SUmIF criteria. This is what I have
that isn't working:
=SUMIF(E:E,">10/1/2007 5:00:00 PM and <10/31/2007 5:00:00 PM",G:G)