Need help regarding issues with SUMIF(S)

I've been trying various ways of getting Excel 2010 to do the following:

IF value in column B=1 AND value in column F=1 THEN add value(s) from column H AND show sum in cell K1

I've tried SUMIF and SUMIFS and have not been able to get either to work: all I get is a value error. It occurred to me that maybe I was using the wrong command or something. Any help would be appreciated. I would also need to repeat this in cells K2-K5 where the value in columns F increments by 1 each time. I have pasted an excerpt from the budget I am attempting to do this in below: hoping that helps. Column E displays WEEKNUM where column I is =sum(E1-43) so it displays weeks 1-5 for the month of November. All other cells are general EXCEPT column H (accounting) and column D (long date). Columns G I AND J are blank.

Thanks in advance!

A B C D E F G H I J K
Food 1 Groceries Friday, November 01, 2013 44 1 $80.00
1 Groceries Friday, November 08, 2013 45 2 $80.00
1 Groceries Friday, November 15, 2013 46 3 $80.00
1 Groceries Friday, November 22, 2013 47 4 $80.00
1 Groceries Friday, November 29, 2013 48 5 $80.00

Try this formula in K1:

=SUMIFS(H:H,B:B,1,F:F,ROWS($1:1))

then copy down to K5.

Hope this helps.

Pete

Thanks a lot Pete!

I've never used arrays, so it wouldn't have occurred to me to add ROWS. I'll have to do a bit of playing with arrays when I get a chance.