View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
arch0072 arch0072 is offline
external usenet poster
 
Posts: 3
Default Sum only if cells are not blank in adjacent column

Hi,
I have a simple scorecard that Ive built with available points in column B
and a score in column C. Sometimes not all the column C's are filled out due
to the process wasn't observe. I only want to sum up total points available
in column B if the adjacent cell in column C has a numeric value.