Lookup with (3) criteria

[Fast Forward]

I have attached a sheet that I have been trying to get to work. I have not been able to find a combination to work with vlookup. Maybe someone here knows how to make this work.

Thank you

[NBVC]

Try this formula:

=SUMPRODUCT(--($A$10:$A$23>=F2),--($A$10:$A$23<=F3),--($C$10:$C$23=F5),$B$10:$B$23)

EDIT:

You'll need to fill in all the date fields in Column A

[Fast Forward]

Thanks for the reply, but I am realy looking for a way to not have to fill-in all the dates in the date column. It gives me a quick visual if more than one job was worked on in any one particular day.

I'm thinking that it will take a macro to get the job done unless you have any other ideas.

Thanks

[NBVC]

The easiest way would be to insert a helper column between columns A and B (that you can hide from view).

And in the new B10 enter formula: =IF(A10,A10,B9) copied down.

Then change the formula in what would now be G7 to: =SUMPRODUCT(--($B$10:$B$23>=G2),--($B$10:$B$23<=G3),--($D$10:$D$23=G5),$C$10:$C$23)

see attached sample.

[Fast Forward]

Thanks for the idea.

A nice simple approach.