Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild cards in SUMIF
Wild cards do not work in SUMIF. =SUMIF(J:J,"10/*/2006",D:D) gives me zero
while =SUMIF(J:J,"10/13/2006",D:D) gives me a correct sum. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild cards in SUMIF
Wildcards in formulas can only be used on TEXT.
Try this: =SUMPRODUCT(--(TEXT(J1:J100,"mmyyyy")="102006"),D1:D100) Biff "Charles" wrote in message ... Wild cards do not work in SUMIF. =SUMIF(J:J,"10/*/2006",D:D) gives me zero while =SUMIF(J:J,"10/13/2006",D:D) gives me a correct sum. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wild cards in SUMIF
P.S.
You can't use entire columns as references in Sumproduct (** unless you're using Excel 2007 Beta). This won't work **: =SUMPRODUCT(--(TEXT(J:J,"mmyyyy")="102006"),D:D) Biff "Biff" wrote in message ... Wildcards in formulas can only be used on TEXT. Try this: =SUMPRODUCT(--(TEXT(J1:J100,"mmyyyy")="102006"),D1:D100) Biff "Charles" wrote in message ... Wild cards do not work in SUMIF. =SUMIF(J:J,"10/*/2006",D:D) gives me zero while =SUMIF(J:J,"10/13/2006",D:D) gives me a correct sum. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Partial String Match & Wild Cards Using VLOOKUP | Excel Worksheet Functions | |||
If Statement Using Wild Cards | Excel Worksheet Functions | |||
wild cards in formulas and functions | Excel Worksheet Functions | |||
How do I use wild cards in nested array formulas? | Excel Worksheet Functions | |||
Wild Cards With Arrays | Excel Discussion (Misc queries) |