Excel - Function.

[liquid]

I'm just working on a spreadsheet, and am looking to create a SUMIF function; however rather than inclusive of a criteria, I need it to be exclusive.

ie: lets say I want to sum all numbers in column A, if they contain anything EXCEPT the statement "4D". How can I do that?

Inclusive would be: =SUMIF(DATA!N2:N2000, "*4D*",DATA!L2:L1500)

[18TWolf]

Re: Excel - Function.

The easiest way to do this would be:

=SUM(DATA!L2:L1500)-SUMIF(DATA!N2:N2000, "*4D*",DATA!L2:L1500)

The ranges should match in the sumif statement either N1500 or L2000

But without seeing exactly what you are wanting to do or what the whole data set looks like... this may not be the best solution. There are other text manipulation options which might work.

[Mitcheh]

Re: Excel - Function.

I used to pwn excel but i dropped out of school

[bart]

Re: Excel - Function.

(...) but i dropped out of school

yes, i got that much from reading your posts.

[Chris]

Re: Excel - Function.

yes, i got that much from reading your posts.

[Canadian Turbo]

Re: Excel - Function.

I use excel a fair bit but for mostly basic operations but I stayed in school

[R_Ethug]

Re: Excel - Function.

i hate excel lol

[liquid]

Re: Excel - Function.

Thanks 18TWolf, that worked great!

Stay in school :thumbsup:

[18TWolf]

Re: Excel - Function.

Its amazing how easy it is to miss the most obvious solution... Glad I could help.

Chris