First, thanks for posting back

Think I understood fairly well all of the multi-conditions that you
originally expressed <g

The only one which proved confusing was this

your original post as expressed:
.. sumif(columnC,"<529999","539999",columnD)

hints strongly at the "opposite" of your clarification:
.. (ie: all project codes between 529999 and 539999)

If ever you really need it as:
.. sumif(columnC,"<529999","539999",columnD)

ie considering:
all project codes less than 529999, and
all project codes greater than 539999
(the 2 "outer" bounds)

then my earlier suggestion would do just that
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GfaCS" wrote in message
...
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!