| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sum if wildcard
Hi, im trying to sum data based on data in another cell and need to
incorporate a wildcard character. My formula is =SUM(IF($G$2:$G$52997=BA2,$M$2:$M$52997,0)) I need to use the asterix (*) wildcard with the cell BA2. Is this possible ? Thanks, Marcel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count wildcard text meeting certain criteria in EXCEL? | Excel Worksheet Functions | |||
| Wildcard Problem.... | Excel Discussion (Misc queries) | |||
| Question regarding wildcard in multi-criteria IF formula | Excel Worksheet Functions | |||
| wildcard in sumproduct? | Excel Worksheet Functions | |||
| Sumif using wildcard | Excel Worksheet Functions | |||
Threaded Mode
