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

Please show sample of what you need

--
Greatly appreciated
Eva


"UCfts" wrote:

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?