Thread: Sum If Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scoops Scoops is offline
external usenet poster
 
Posts: 108
Default Sum If Function


Cowgirl wrote:
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,

:)


--
Cowgirl


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