View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DJS DJS is offline
external usenet poster
 
Posts: 31
Default sumproduct of columns

Hello~
For each row in my report I need to add columns ES:EZ and determine if the
val is equal to zero, then return a count of all rows where columns ES:EZ
added up to 0 .
Can I use Sumproduct for this or is there another way?