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
|