View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GD GD is offline
external usenet poster
 
Posts: 83
Default Counting, 2 criteria

Hi, if i'm looking for a formula which will total the cumulative values in
cells Q3:Q3000, but only if the criteria in two other sets of cells are
present, ie A3:3000 has a date in the month of January and P3:P3000 has the
text "KT" in it, how would I go about this?
The values in Q3:3000 are in pounds, so i'd be looking for a cumulative
figure if the preivous two criteria are met in other cells.

Cheers