Hi Biff

Is there a way this formula can further cater to below?

For example
I have local Sg, local CN, local CZ, local MY fields and i'm trying to
achieve below:

SUM all for local SG compared to SUM all for the rest of the regions,
excluding SG.

=SUMPRODUCT(--(ISNUMBER(SEARCH("Local",$E$24:$E$43))),--($G$24:$G$43="Actual"),$H$24:$H$43)
--
judy goh


"T. Valko" wrote:

Is the wildcard feature not available in SUM+IF

No, it can't be used directly in those functions.

Try this:

=SUMPRODUCT(--(ISNUMBER(SEARCH("Local",$E$24:$E$43))),--($G$24:$G$43="Actual"),$H$24:$H$43)


--
Biff
Microsoft Excel MVP


"judy" wrote in message
...
Hello!
I was able to use wildcards in SUMIF formulas but it just don't work in
SUM+IF statement. Is the wildcard feature not available in SUM+IF
statement
or there's something wrong with my formula?

=SUMIF($E$2:$E$300, "Local*", $F$2:$F$300)
This will help me sum up the F column if column E contains Local 1, Local
2,
Local 3 etc

The formula I'm trying to create now is as follow
=SUM(IF(($E$24:$E$43="Local*")*($G$24:$G$43="Actua l"),$H$24:$H$43))
However, the formula is not looking at Local 1, Local 2, Local 3 of column
E. It doesnt seem to recognise this feature.

Can any of you help advise me on above? Thanks soo much!!!