C
ciojr
i have the following formula
=IF(MONTH($B:$B)=MONTH(J1),+SUMIF($H:$H,"auto",$F:$F)+SUMIF($H:
$H,"auto",$E:$E))
problem is i am getting results (sum) of all of column F and E
I only want the amounts in F and E if the applicable row is the month
of jan
B E F H
01/01/07 200.00 55.00 auto
01/15/07 201.00 0.00 auto
02/01/07 100.00 25.00 auto
02/15/07 125.00 35.00 milk
So for Jan - i should get 456.00
What am i missing here.
=IF(MONTH($B:$B)=MONTH(J1),+SUMIF($H:$H,"auto",$F:$F)+SUMIF($H:
$H,"auto",$E:$E))
problem is i am getting results (sum) of all of column F and E
I only want the amounts in F and E if the applicable row is the month
of jan
B E F H
01/01/07 200.00 55.00 auto
01/15/07 201.00 0.00 auto
02/01/07 100.00 25.00 auto
02/15/07 125.00 35.00 milk
So for Jan - i should get 456.00
What am i missing here.