sum column if multiple criteria match

[Dena]

I am trying to create a formula that will sum column H if column B = A2 and column J is blank and column I contains a date of the current month. The formula is on another sheet but the data pulls from the Student worker pay sheet. A2 is on the budget sheet.

I have no clue how wrong I am
=SUMIFS('Student Worker Pay'!H:H,'Student Worker Pay'!B:B,$A2,'Student Worker Pay'!J:J,"",'Student Worker Pay'!I:I,MONTH(NOW()))

Capture1.PNGCapture.PNG

[day92]

Why upload a pic when you can upload the spreadsheet so it can be tested??

[CheshireCat]

Column I contains dates, but you're comparing it to a month number.

[BenMiller]

Can't see your pictures but how about (put the sheetnames in yourself)

=sumproduct(--(B1:B100=A2),--(J1:J100=""),--(MONTH(I1:I100)=MONTH(NOW())),B1:B100)

[CheshireCat]

I suggest using EOMONTH in place of MONTH in case of dates spanning over a year.

[Dena]

Nothings working....

the formula will go in column f on student budget balance

12-13 budget-test.xlsx

I want it to add column H if column B matches A2,etc on budget sheet and if Column J doesn't say Late and column I has a date that falls in the current month.

HELP

[Cutter]

Try this in F2 and down:

Please Login or Register  to view this content.

[Dena]

Try this in F2 and down:

Please Login or Register  to view this content.

Thank you, that worked