"Mark74w1" wrote:
'joeu2004 Wrote:
"Mark74w1" wrote:
This formula,
=SUMIF('Cost Plus Invoice'!O8:O1500,"p",'(Cost Plus Invoice'!T8:U1500)
[....]
you can simply negate it, to wit:
=-SUMIF('Cost Plus Invoice'!O8:O1500,"p",'(Cost Plus Invoice'!T8:U1500)

Joe, Thank you for the response on this problem. For some
reason, when I entered the corrected formula it opens my
documents looking for a file. The reply by Mr. Busch worked,
however I still want to find out why this formula didn't work
so that I could use it as well.

I had copy-and-pasted your posted formula exactly as you had written it, not
realizing it has a typo: the left-parenthesis before the word "Cost" on the
right. Claus corrected your typo without drawing your attention to it.
Modifying Claus's formula:

=-SUMIF('Cost Plus Invoice'!O8:O1500,"p",'Cost Plus Invoice'!T8:U1500)

Joe,
Thank you again for the help. I didn't see that either.
Can I ask you one more question? I've tried to make this work with no success. =SUMIF('Cost Plus Invoice'!O8:O1500,"p",'Cost Plus Invoice'!T8:U1500)+('payroll'!O8:O1500,"t",'payrol l'!T8:U1500).
The purpose of this formula is to sometimes add the two, or to have one entered if the other is blank.
Also can you, if payroll is "t" and cost plus is "p" then total the two.
I hope I'm not taking advantage of your expertise, but these two solutions could greatly simplify my 9 page spread sheet.
Thanks Mark