Excel sum if

[Narasinga Reddy]

In an excel file , I have few sheets from Jan to Dec. & in one sheet as summary sheet which will have the names of the all the employees. And, I have to sum one cell from all the sheets of one employee e.g. the formulas is =sum(Jan:dec!s7), and the problem with this formula if I insert a row it will sum up for the wrong employee. Hence, I need a formula for sum with reference to the particular employee only for all the sheets. Pls. help.

[Good Guy]

Post by Narasinga Reddy
In an excel file , I have few sheets from Jan to Dec. & in one sheet

as summary sheet which will have the names of the all the employees.
And, I have to sum one cell from all the sheets of one employee e.g.
the formulas is =sum(Jan:dec!s7), and the problem with this formula if
I insert a row it will sum up for the wrong employee. Hence, I need a
formula for sum with reference to the particular employee only for all
the sheets. Pls. help.


=SUMIF(B2:B5, "John", C2:C5)

In this example, the criteria is applied the same values that are being
summed. If you want, you can apply the criteria to one range and sum the
corresponding values in a different range. For example, the formula
=SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5,
where the corresponding cells in the range B2:B5 equal "John."

Source:
<http://office.microsoft.com/en-gb/excel-help/sumif-function-HP010062465.aspx>

You can post a link to your excel sheet for us to see it to give you a
specific solution. Also, you will get better results if you post by
subscribing to excel newsgroups such as:

<http://peach.ease.lsoft.com/archives/excel-g.html>
<http://peach.ease.lsoft.com/archives/excel-l.html>

The second link is for VBA and more advanced stuff while the first link
is for routine things like forumulas and tricks with formulas.

Good luck.