View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Haz Haz is offline
external usenet poster
 
Posts: 46
Default Countif by match two columns

Hi

I am trying to match 2 cells in different cols and then sum the adjcent cols
up.

In A2 i have A002 I would like to find this in Col G then sum d2 and
subtract this from j2 if there is a match.

Any help would be appreciated.

Thanks