|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
01-09-2007, 08:53 AM
|
|||
|
|||
|
Sumif for wildcard character
I need to sum column "H" if a condition is met in column "A" and column "E". "A" contains names followed by one of theses characters: < > ^. Column "E" is Yes or No. I need the sum of all names followed by <.
Column A: Jane Smith < Column E: Yes Column H: 12.00 I have tried this formula or numerous variations of this formula and it returns zero or #value. Can you help? =SUM(IF('Training Hours'!A4:A2000="*<",IF('Training Hours'!E4:E2000="Yes",'Training Hours'!H4:H2000))) 
|
|
#2
01-09-2007, 09:16 AM
|
||||
|
||||
|
Try:
=SUM(IF(Isnumber(Search("<",'Training Hours'!A4:A2000)),IF('Training Hours'!E4:E2000="Yes",'Training Hours'!H4:H2000))) confirmed with CTRL+SHIFT+ENTER or =Sumproduct(--(Isnumber(Search("<",'Training Hours'!A4:A2000))),--('Training Hours'!E4:E2000="Yes"),'Training Hours'!H4:H2000) confirmed with ENTER
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
