Possible to have countif/ sumif by setting print area?

[jp16]

Hi, I have a spreadsheet where I take down the cheques i received for the day. I have 3 different bank account in whic I will deposit the cheques into. Column A is the cheque number, B is the company. Column C, D, E stand for Bank 1,2 and 3. If i received a cheque of $100, example HSBC123456 from ABC Pte Ltd. Column A, will be HSBC123456. B will be ABC Pte Ltd. Then $100 will be at either column C, D, E. Depending which bank account i deposit to. I will have to set "print area" depend on the date. Refer to attachment, is it possible to have a countif / sumif by setting a print area? For example, the total number of cheque deposit into individual bank and the value. If its possible, could the formula be set to the "header" or "footer"?





sample2.xlsx

[benishiryo]

hi jp16, see if this works for u. i only did 1 eg. i did a formula separated from your table & use a textbox to refer to the formula. I also inserted 1 row at the start to put in the header. i then go to Sheet Options to repeat row 1 at the top. so every page will have row 1's header