| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statements using words
With the below data in Sheet1 , can you try the below formula
A2 to D6 Jan|Section1|SubSection1|20 Jan|Section1|SubSection1|20 Jan|Section1|SubSection1|10 Feb|Section1|SubSection1|20 Feb|Section1|SubSection1|20 =SUMPRODUCT((ISNUMBER(SEARCH("Jan",Sheet1!A2:A6,1) ))*ISNUMBER(SEARCH("SubSection1",Sheet1!C2:C6,1)), D2:D6) If this post helps click Yes --------------- Jacob Skaria "AdrenalinR" wrote: No it just gave me a value of 0. "Jacob Skaria" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in words | Excel Worksheet Functions | |||
| how to convert numeric to words Example 525 in words (Twenty five | Excel Discussion (Misc queries) | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| words | Excel Discussion (Misc queries) | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
Hybrid Mode
