Nesting formulas within SumIF

cloay001

New Member
Joined
Jul 25, 2007
Messages
2
Hi,

I am trying to use the Concatenate function within the criteria section of the sumIF syntax.

SUMIF(range,criteria,sum_range)

If I remove the concatenate function and replace with the intended result the SumIF function works perfectly. I am satisfied that there are not problems with the concatenate calculation itself. As soon as I nest in the concatenate function it stops working.

Can anyone advise if it is possible to nest a concatenate function in the criteria part of the SumIF function.

I am aware that I can easily use Pivot tables to acheive the result I require, however due to functionality requirements a pivot table is not suitable.

Thanks - any advice is appreciated!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi, welcome to the board!

Can you provide some sample data, criteria, and expected results?
 

cloay001

New Member
Joined
Jul 25, 2007
Messages
2
Thanks Hotpepper

I have resolved this issue, not a concatenate or nesting problem at all. The data I am using is exported from another database and it seems it has hung on to some hidden formatting of some sort which means that when it is compared as a criteria it doesn't match my dataset.

Very frustrating because as far as the "naked" eye goes the cells match perfectly.

Thanks for your help on this, I will keep and eye on this forum - looks useful.
 

Forum statistics

Threads
1,181,658
Messages
5,931,269
Members
436,785
Latest member
KingGideon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top