Thread: SUMIF summing multiple columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
juliejg1 juliejg1 is offline
external usenet poster
  
Posts: 81
Default SUMIF summing multiple columns
I'm confused by your answer

"Don Guillett" wrote:


167 169
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"juliejg1" wrote in message
...
I have the following formula in cell E9:
=SUMIF(Details!$X$6:$X$167,""&0.3,Details!$AF$6:$ AG$169)

It seems there is a problem with the SUMIF summing more than one column
(AF6:AG169). Any suggestions?


Reply With QuoteReply With Quote