Can you post a small sample of your data so I can what you're trying to do?

Geezzzz! I left out the most important word.

Can you post a small sample of your data so I can see what you're trying to
do?

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Can you post a small sample of your data so I can what you're trying to
do?

--
Biff
Microsoft Excel MVP


"judy" wrote in message
...
Hi Biff
I'm encountering another issue.
the formula is working for the Product A.
when i applied the formula to Product B, the values show as 0 (though the
details have a value tied to it)

I tried to re-calculate the formula by doing a Ctrl-ALT-F9 but it's still
showing as 0 values. Any idea why this is happening?

Product A, Product B
Local SG 25, 0
Local Others 7, 0
Sub 8,0
--
judy goh


"T. Valko" wrote:

For "Local SG" :

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

For all others:

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



--
Biff
Microsoft Excel MVP


"judy" wrote in message
...
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!!!