formula for automatic calculation

[Aboiy Del Rio]

Hi Anon,

Im not quite familiar in using complicated formula, but
can you explain a little further to me the formula you've
just given : =SUMIF(B1:B10,"Engineering",A1:A10)

Actually, its a day to day entry wherein they put in one
column, assuming "B column" all the figures and in "C
column" the particular name of dept.,other succeeding
columns are just particulars like receipt no. and dates.
Amount figures column B are in small amounts. Now if I
consider B1:B10 as the figure how it was able to know the
specific dept.name if it is located in another column.

I cannot change the column assignment use by our
accounting dept., i just want to have a separate report
for total expenses of each dept. and their over expense
budget.

Im a bit confuse.

For your kind assistance.

aboiy

 

[Anon]

Hi Anon,

Im not quite familiar in using complicated formula, but
can you explain a little further to me the formula you've
just given : =SUMIF(B1:B10,"Engineering",A1:A10)

Actually, its a day to day entry wherein they put in one
column, assuming "B column" all the figures and in "C
column" the particular name of dept.,other succeeding
columns are just particulars like receipt no. and dates.
Amount figures column B are in small amounts. Now if I
consider B1:B10 as the figure how it was able to know the
specific dept.name if it is located in another column.

I cannot change the column assignment use by our
accounting dept., i just want to have a separate report
for total expenses of each dept. and their over expense
budget.

Im a bit confuse.

For your kind assistance.

aboiy

The formula
=SUMIF(B1:B10,"Engineering",A1:A10)
adds up figures in A1:A10 where the corresponding entries in B1:B10 are
"Engineering".
You can see this in more detail with examples by looking up SUMIF in Help,
where it explains
=SUMIF(range,criteria,sum_range)

If your figures are in column B and your departments in column C, you will
need to use
=SUMIF(C1:C10,"Engineering",B1:B10)
I have just used ten row ranges as an example. You can adjust the length as
required.

 

[akk]

Hi

The criterion in thsi formula is "engineering. The range
that is validated is B1:B10 and where true(i.e. criterion
met), A1:A10 is summed up.

Hope this is clear

 

[Aboiy Del Rio]

Thanks a lot Anon & AKK for the assistance you've extended
to me. Everything starts to be clear now.


aboiy