Hi

Enter this formula in C1:

=if(A1="Private",D2-D1,"")

Regards,
Per

"Redders527" skrev i meddelelsen
...
I want to a sum of 2 cells to be placed into another cell, but only if a
different cell has a certain word in it ( so if cell A1 has "Private"
typed
in it, the sum of D2-D1 will be placed into B1, if any other words are
written in A1 then the sum of D2-D1 to be placed in C1)
Hope this makes sence? I does in my head!
Regards
Craig