Need help with SUMIF formula
 

I need someone to help me please.

Example:
cell a2 = 5,000
cell a3 = 10,000
cell a4 = 90
cell b2 = "blank"
cell b3 = 5,000
cell b4 = 90

i am writing a SUMIF problem =sumif(a4:b4,90,a3:b3)

but what i need is the sum of cells a3 if a2 is blank, if cell a2 has a
number then i need that number. in other words the total of this formula
needs to = 10,000 not 15,000.

Can anyone help me?

Susan

Need help with SUMIF formula
 

Hi,

If I understand correctly maybe this in c2

=IF(COUNT(A2,B2)<2,A2+A3,A2+B2)

Mike

"Susan" wrote:

I need someone to help me please.

Example:
cell a2 = 5,000
cell a3 = 10,000
cell a4 = 90
cell b2 = "blank"
cell b3 = 5,000
cell b4 = 90

i am writing a SUMIF problem =sumif(a4:b4,90,a3:b3)

but what i need is the sum of cells a3 if a2 is blank, if cell a2 has a
number then i need that number. in other words the total of this formula
needs to = 10,000 not 15,000.

Can anyone help me?

Susan

Need help with SUMIF formula
 

Not very clear but here goes:
=IF(isblank(A2),A3,A2)

I do not see why you use the word 'sum'
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Susan" wrote in message
...
I need someone to help me please.

Example:
cell a2 = 5,000
cell a3 = 10,000
cell a4 = 90
cell b2 = "blank"
cell b3 = 5,000
cell b4 = 90

i am writing a SUMIF problem =sumif(a4:b4,90,a3:b3)

but what i need is the sum of cells a3 if a2 is blank, if cell a2 has a
number then i need that number. in other words the total of this formula
needs to = 10,000 not 15,000.

Can anyone help me?

Susan

Need help with SUMIF formula
 

may be ?

=INDEX(A1:A4,MATCH(TRUE,ISBLANK(B1:B4),0)+1,0)

use ctrl + shift + enter


On Oct 16, 11:33*pm, Susan wrote:
I need someone to help me please. *

Example:
cell a2 = 5,000
cell a3 = 10,000
cell a4 = 90
cell b2 = "blank"
cell b3 = 5,000
cell b4 = 90

i am writing a SUMIF problem =sumif(a4:b4,90,a3:b3)

but what i need is the sum of cells a3 if a2 is blank, if cell a2 has a
number then i need that number. *in other words the total of this formula
needs to = 10,000 not 15,000.

Can anyone help me?

Susan