Thread: Offset
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MichelleT MichelleT is offline
external usenet poster
  
Posts: 7
Default Offset
I need to sum the total from column A to D, the number of column is varies
A B C D E F
1 Jan Feb Mar Apr May
2 Sample x x x x x

My formula returns a zero, pls check what's wrong
=sumif(a2:a2,a2,offset(A2:A2,0,5,05)


Reply With QuoteReply With Quote