IF function performing logical test on multiple cells

Hi everyone,

So my current problem is that I want to use the IF function to perform the logical test on a column of cells instead of just one cell.

I realize that this can be done by copying the IF function to multiple cells but the way my spreadsheet is currently set up doesn't allow me to do that.

To be more specific, I am trying to use the below function:

=IF(DATE(YEAR('SheetTwo'!$P:$P),MONTH('SheetTwo'!$P:$P),1)='SheetOne'!C3,SUMIF('SheetTwo'!$B:$B,"P",'SheetTwo'!$R:$R),0)

What I am trying to do is to go through a column of dates, extract the month and compare each month with a specific month. If the date matches up, I want to sum up data in an adjacent field based on another "equal to" criteria.

I know the SUMIF portion is working fine but I am at a lost as to how to perform an IF logical test on a column of cells (compare a column of cells one by one to another specific cell) all in one cell (without having to use multiple cells and summing things up).

Maybe this will be an interesting riddle for you guys =)

Any help or advice is much appreciated!

I forgot to mention that Excel doesn't let me use the IF function on a column of cells, haha. Well, it does but it isn't working as I expect it to as described above.