Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count with multiple criterias | Excel Worksheet Functions | |||
sumif with multiple criterias | Excel Worksheet Functions | |||
DCOUNT WITH MULTIPLE CRITERIAS | Excel Worksheet Functions | |||
countif help for multiple criterias | Excel Worksheet Functions | |||
Multiple Data Validation Criterias | Excel Worksheet Functions |