sumif question I think

[Martin]

I have 3 columns product name,projected,ordered. In a fourth column I need
to have 1st projected -ordered on all rows where the product name stays the
same.

Some thing like this...
product proj order
a 100 10 90
a 15 75
b 200 30 170
b 10 160
b 400 -240
.....

Thanks
Martin

 

[Bob Phillips]

I think this is what you mean

=IF(B2<>"",B2-C2,D1-C2)

Entere in d2 and copy down

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)