# Complex SUMIFS (SUMPRODUCT?) formula w/ wildcards (SEARCH?)

1. ## Complex SUMIFS (SUMPRODUCT?) formula w/ wildcards (SEARCH?)

See attached if you're ever so inclined to follow allong...

20121011 Excel Help ex.xlsx

Sheet1:
Sales totals are populated: the "Sales Transaction", "Overhead", and the overall "Net" for each product. The sales totals are reported each month, with the month being grouped by quarter.

Sheet2:
I would like to perform a calculation to sum the "Net" for each product - by quarter. I really only care about the yellow "Object" (Object 1, 2, 3) products, so I devised a rather simplistic (and incorrect) SUMIFS statement just to show the general idea behind the calculation I am trying to execute in cell B5. Just to elaborate though, in cell B5, I'm attempting to display the total "Net" generated in '1st Qtr' (Jan-Mar) where the product is "Object*" (wildcard to include Object 1-3).

I'm certain this is a SUMPRODUCT job, but I didn't want to type out a bunch of garbage that would be incorrect anyway.

Any help would be certainly appreciated.

(Running Windows 7, Excel 2007 if it matters)

2. ## Re: Complex SUMIFS (SUMPRODUCT?) formula w/ wildcards (SEARCH?)

Hi Mark,

Try using below formula:-

Formula:

See attached with little customization 20121011 Excel Help ex.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

3. ## Re: Complex SUMIFS (SUMPRODUCT?) formula w/ wildcards (SEARCH?)

I figured it probably had something to do with the merged cells...

Thanks for your help, works like a charm.

4. ## Re: Complex SUMIFS (SUMPRODUCT?) formula w/ wildcards (SEARCH?)

you are welcome mark.. cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1