=sumif(A1:AC2000,"Johnny",C1:AF2000)

assumes no invoice number will equal a Name.
--
Regards,
Tom Ogilvy

"Juco" wrote in message
. uk...
I have 3 columns for each month...
column A name
column B invoice number
column C value (£s)
Then column D,E,F for the next month and so on for 12 months
In each month a name may appear several times and over the year
quite a few times in the various months/columns.

Is there an easy way to find out the value of a given Name and the total
value for the year for that name?
All the columns are on one sheet of a workbook.

Thanks