Applying sum function to a formula

  • Thread starter Thread starter junki3
  • Start date Start date
J

junki3

This will be a little hard to explain but I have a spreadsheet tha
keeps track of all motorcycle deals my employer does and i am trying t
create a summary of how many units were sold in a certain month.
have inserted a function to show a number depending on what month th
deal went through. I would like to know how to sum these numbers up.
I cannot use the regular SUM function because the cells i am trying t
sum already have functions in them. How do I go about doing this
 
You can sum any cell that is numeric, whatever is in it and is bringing back a
nunber. Post a few more details though, as it sounds like either SUMIF or
SUMPRODUCT will do what you want.
 
Hi

if i understood you correctly you want to some only the units for a
specific month. Then use SUMIF
e.g. =SUMIF(A1:A90,1,B1:B90)
In A1:A90 the month is entered
in B1:B90 the corresponding deals

Frank
 
Hi Junki3!

Re: "I cannot use the regular SUM function because the cells i am
trying to sum already have functions in them."

SUM will sum the results of your formulas.

As for summing based upon month where you have a month number cell:

=SUMIF(D$1:D$200,=E1,B$1:B$200)

Returns the sum of entries in B1:B200 where the number in the
corresponding row in column D equals the number in E1.


But if we want to put the value in the formula we need to use:

=SUMIF(D$1:D$200,”=”&10,B$1:B$200)



Note the quotation marks around the = and the use of & to join it with
the value we are using.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi again,
I am pretty new at excel so I may have made this a whole lot harde
than it need be but I will go into more detail.
I have input a function to assign a numerical value to a cell so I ca
tell whether a unit is an atv, sport bike, cruiser or dirt and sold o
not. ie:=type(cell)+0,=type(cell)+13,=type(cell)+26 (so sa
=type(cell)+0, I know it's an atv because i have assigned 1 & 2 t
atvs, 1 being not sold, 2 being sold etc...). I have spaced the adde
value apart because I then used another function in a separate cel
assigning a number based on what month is typed i
(ie=if(H2="MAY","50",""). What I am going for is if I add up the firs
value and the second value, it will give me my ultimate value t
determine what the unit is, whether it was sold and what month it wa
sold in. Say the SUM function works properly, a sold atv unit sold i
MAY, the value would be 52. I can sum the results of the type functio
but I cannot get the sum function to work on both results...
 
Hi junki3!

Cutting a long answer sideways:

You've used:
=IF(H2="MAY","50","")

Does this work
=IF(H2="MAY",50,"")

By putting quotation marks around the 50, you're getting 50 returned
as text and not as a number. That's why the SUM won't add them up.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
hi,
thankyou so much, u helped me so much. Completely obvious that i do
not know anything about excel but i'm learning ;)
 
Hi junki3!

That's the way to learn!

Give it your best shot and if it doesn't work then as soon as your
start tearing your hair out, post a question showing what you have,
what you want, what you've tried. Very often, your own logic will have
got you nearly there and the solution is only a tweak away.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top