Thread: Conditional Sum Argument results do not equal cell results Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Randy R Mullins Randy R Mullins is offline
external usenet poster
  
Posts: 1
Default Conditional Sum Argument results do not equal cell results Excel
I am using a consitional sum with three variables =SUM(IF('Current Period
NSA'!$D$8:$D$3000=A23,IF('Current Period NSA'!$E$8:$E$3000=B23,IF('Current
Period NSA'!$H$8:$H$3000=C23,'Current Period NSA'!$AB$8:$AB$3000,0),0),0))
The argument itself shows the correct answer when I edit the formula but when
I close the argument window the cell shows a value of 0.

Reply With QuoteReply With Quote