View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default sumif or countif not sure

i want to sum the numbers in column B based on the criteria in column A and
give a count. not sure what the combo is.

Col A col b
1 9.99
1 9.99
2 10.00
2 30.00

so i want the result to show
1 19.98
2 40.00