View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default multiple conditions sum

"Brigitte" wrote:
I'm getting a #value. Do you know how to troubleshoot this type of
output?


The ranges: $A$2:$A$10, $B$2:$B$10 need to be identical in size
Re-check this in your adaptation of the formula to suit over there ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---