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