Nesting formulas within SumIF

[cloay001]

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!

 

[Scott Huish]

Hi, welcome to the board!

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

 

[cloay001]

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.