View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UCfts UCfts is offline
external usenet poster
 
Posts: 2
Default SUMIF and multiple criteria

I have a spread sheet with approx 3000 rows of info

The columns A and D of information have thee the criteria I would like to use.
Column A is a 4-character alpha-numeric field
Column D is a Alpha field

For each instance of the value in column A which meets the criteria in colum
D, I need to SUM column C.

Can anyone help?