View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Sum of results of multiple criterias

Say I have a report sent to me as below:-

----------------------------------------------
A B C
----------------------------------------------
Emile Heskey ASSL1NP 12
Wayne Rooney ABCV1NP 8
Peter Crouch ABCV1NP 3
Wayne Gerrard ASSL1NP 5
Martin Crouch ASSL1NP 10
Ryan Heskey ABCV1NP 7
Crouch Tiger ASSL2AM 4
----------------------------------------------

Now I want to create a table which automatically find name that contain
Crouch AND also contain the letters "SSL" in his tag in column B, and then
sum the corresponding numbers in column C. I need to do this also for other
names and tabulate them in a table. Help please.