Sumif with Vlookup

  • Thread starter Thread starter muziq2
  • Start date Start date
M

muziq2

Hi all,

I'm trying to incorporate a vlookup into a sumif function. The proble
is that I want the criteria to be greater than or equal to. My formul
works when the criteria is only equal to.

=SUMIF('inceptio
losses'!J:J,VLOOKUP($H$1,dates!$I$43:$J$54,2,0),'inceptio
losses'!L:L)

The above formula gives the range, then looks at the month that i
manually entered in cell H1, which then goes to a table and gives
date value, and then sums the cells matching that criteria.

I need to know how to enter >= in the above formula. When I enter th
criteria as being >= I receive the message box that says the formul
contains an error. I have tried with and without quotations. Wit
quotations returns zero. Without returns the error box.

Thanks,

Jef
 
=SUMIF('inception
losses'!J:J,">="&VLOOKUP($H$1,dates!$I$43:$J$54,2,0),'inception
losses'!L:L)
 
Back
Top