Thread: Total of a specific name
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billy Liddel Billy Liddel is offline
external usenet poster
  
Posts: 527
Default Total of a specific name


Tia

An array formula entered Ctrl + Shift + Enter

=SUM(IF(MOD(COLUMNS(D:Z),2)=1,D10:Z10))

You can copy down

Regards
Peter
Reply With QuoteReply With Quote