Function Question

robbiev

New Member
Joined
Sep 9, 2002
Messages
38
In this function, how do I tell excel to look for any real number, instead of a spacific number.

=SUMIF(C2:C999,"ANY REAL NUMBER",E2:E999)

Thanks :) Robbie
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
care to give an example? I take it from your previous posts you don't mean "real" in the mathematical sense of real numbers....

paddy
 

robbiev

New Member
Joined
Sep 9, 2002
Messages
38
Heh...actually, I think I do mean an actual real number, in the math sence...um, any whole number such as 0, 3, 140, 2000, etc.
:)
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
On 2002-09-11 22:24, robbiev wrote:
In this function, how do I tell excel to look for any real number, instead of a spacific number.

=SUMIF(C2:C999,"ANY REAL NUMBER",E2:E999)

Thanks :) Robbie

You can't as such... but

=SUMPRODUCT(ISNUMBER(C2:C999)+0,E2:E999)

would.

What are you trying to accomplish?
 

robbiev

New Member
Joined
Sep 9, 2002
Messages
38

ADVERTISEMENT

it worked! thanks! :)
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
On 2002-09-11 22:28, robbiev wrote:
Heh...actually, I think I do mean an actual real number, in the math sence...um, any whole number such as 0, 3, 140, 2000, etc.
:)

E.g.:

=SUMPRODUCT((F3:F5-INT(F3:F5)=0)+0,G3:G5)
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
On 2002-09-11 22:28, robbiev wrote:
Heh...actually, I think I do mean an actual real number, in the math sence...um, any whole number such as 0, 3, 140, 2000, etc.
:)

Aladin beat me to it, but just FYI, the reals include the irrational numbers, which are non-repeating / nonterminating decimals. The set of real numbers is not co-extensive with the set of integers.

Paddy
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,088
Members
412,567
Latest member
mm1
Top