Hey Max,

First off, thank you for responding. I really do appreciate your time and
input.

Secondly, my overall intention with this formula was to look at each row and
if the criteria matched, to add up the dollar amount in that row.

For example, Column "A" is a business unit, Column "B" is a sub code, and
Column "C" is a project code. The dollar amounts reside in Column "D".

My first intent was to say, if my criteria matches columns "A", "B", AND
"C", then sum up the dollar amounts in "D".

On top of that, I also wanted to be able to search "C" for a range of
project codes (ie: all project codes between 529999 and 539999) instead of
just one code.

That's what I tried to convey with the below formula, but obviously wasn't
super successful. I'll try to be extra clear with any future requests.

Again, thank you!

"Max" wrote:

.. then do a sumif(columnC,"<529999","539999",columnD)

was wondering what you meant by your pseudo formula above? it was a bit
misleading to put it that way
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---