excel month lookup

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top