sumif trying to get text value

[robcarr]

Hi,

I have a small table to display info

I am using this formula and the large formula(in another column) to sort the data

=IF($L23=0,0,SUMIF($G$4:$G$15,$L23,D$4$15))

this formula works fine on numeric values but when it comes accross a text value it displays 0, how can i get the text value to be displayed,

L23 has the large formula which works out the values in order, I need the formula above to give me the other info that is to the left of the original data. It all works fine except for a text value, is it possible to do this,

I dont want any coding i need this to auto show the data correctly.

thanks



Hope this is of use, Rob.

 

[xlbo]

SUMIF cannot work on text as it is an aggregation function

Is the "text value" in L23 ?

If so then

=if(istext($L23),$L23,if($L23=0,0,SUMIF($G$4:$G$15,$L23,D$4$15))

Otherwise please give an example of where the text may be located in your data...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AnotherHiggins]

Have a look at SumProduct.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.