Sum If Function

[Cowgirl]

Can anybody help me with the correct way to enter a SumIF Function wit
numberic and alphabetic properties? My sum should be something lik
C3-A3,D3 If E3 = September - I have done this before however I thin
the way I am inputting this is wrong.

Awaiting your replies -

Many many thanks,

:

 

[Scoops]

Can anybody help me with the correct way to enter a SumIF Function with
numberic and alphabetic properties? My sum should be something like
C3-A3,D3 If E3 = September - I have done this before however I think
the way I am inputting this is wrong.

Awaiting your replies -

Many many thanks,

Hi Cowgirl

From your information, I think you want in D3:

=If(E3="September",Sum(A3:C3))

SUMIF requires the evaluated range to be the same length as the sum
range.

Regards

Steve

 

[Cowgirl]

Hi Steve,

Many thanks for your reply. I tried your sum however received a FALSE
calc rather than a number figure which is what I am looking for.
Basically, I am working out P&L Forecasts for the year and am trying to
use the sum based on Purchase and Sales for single months. Therefore
the sum should be sale-purchase-fee only if month is Aug, Sept, Oct
etc. Rather than having singular sheets - I am trying to populate one
sheet as simply as possible. Do you have any more suggestions?

Kindest regards,

Sadie

 

[Scoops]

Hi Steve,

Many thanks for your reply. I tried your sum however received a FALSE
calc rather than a number figure which is what I am looking for.
Basically, I am working out P&L Forecasts for the year and am trying to
use the sum based on Purchase and Sales for single months. Therefore
the sum should be sale-purchase-fee only if month is Aug, Sept, Oct
etc. Rather than having singular sheets - I am trying to populate one
sheet as simply as possible. Do you have any more suggestions?

Kindest regards,

Sadie

Hi Sadie

OK, I see it a little more clearly now, though I'm still not sure what
you're trying to achieve with "C3-A3,D3", try:

=IF(OR(E3="August",E3="September",E3="October"),C3-A3,0)

Where the C3-A3 is, replace with the actual calculation you're doing.

That you got a FALSE result from the first formula (I didn't include an
"else" statement) suggests that the cell you're evaluating doesn't
actually contain the string "September". Where you and I might know
that "Sep", "Sept" or "9" might mean September, remember that Excel is
literal and the cell must match exactly.

Regards

Steve

 

[Cowgirl]

Hey Steve,

Many thanks for your help - your formula has prevailed!

Wonderful - It has helped me out immensely!

Have a great evening and thank you again!

Kindest regards,

Sadi