If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Logical functions

Thread starter rami79
Start date Nov 16, 2005

R

rami79

New Member

Nov 16, 2005

#1

Hi guys,

I need to do the following:

IF A1="yes" and A2>0 then sum B1:B3, if not 0
IF A1="No" then Sum C1:C3

Thanks
Rami

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?

Click here to reveal answer

MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Sort by date Sort by votes

Chitosunday

Well-known Member

Nov 16, 2005

#2

is that one formula with three conditions or two formulas with two conditions

Upvote 0

R

rami79

New Member

Nov 16, 2005

#3

one with 3

Upvote 0

Chitosunday

Well-known Member

Nov 16, 2005

#4

=IF(AND(A1="yes",A2>0),SUM(B1:B3),IF(A1="no",SUM(C1:C3),0))

Upvote 0

R

rami79

New Member

Nov 16, 2005

#5

thanks

Upvote 0

You must log in or register to reply here.

Similar threads

H

Solved

About the sum function

Replies: 2

Views: 68

Sep 6, 2023

Joe4

R

Solved

Apply color to shapes using the color of other cells

Replies: 8

Views: 139

Thursday at 10:12 AM

ruliann

R

N

Solved

Sum not working in Excel365

Replies: 3

Views: 152

Mar 14, 2023

nora1212

N

M

Solved

Creating Continuous, Growing List

Replies: 6

Views: 203

Mar 30, 2023

lrobbo314

S

Question

Need Help - Formula

2

Replies: 16

Views: 481

Jul 2, 2023

ststern45

S

Share:

Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email Link

Forum statistics

Threads: 1,203,103

Messages: 6,053,539

Members: 444,670

Latest member: laurenmjones1111

Share this page

Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email Link

Top