Okay, next version :-)


=SUMIF(D:D,"*value*",A:A)

--
HTH

Bob Phillips

"William Francis" wrote in
message ...
Thanks for that Bob. I have tried that, however this doesn't appear to
work
as some cells only contain this text as part of the cell value, and not
necessarily at the start of the cell?

Sorry for not explaining that earlier.

Thanks,
Will

"Bob Phillips" wrote:

Hi Will,

yes, not hard

=SUMIF(D:D,"value",A:A)

--
HTH

Bob Phillips

"William Francis" wrote in
message ...
Hi Folks,

Can anyone advise whether it's possible to add together all cells in
column
D where the cell in the same row and column A contains specific text?

Thanks,
Will Francis