# Tagged Questions

1answer
3k views

### How do I add values in column B if column A contains the same employee surname more than once?

State of Data: I have column A which has names of employes and column B has number of hours. How do I add the hours if column A contains same employee surname more than once? I have been using what I ...
2answers
900 views

### Positive result, negative result and current balance. How do you make starting balance show current result?

I have 3 columns: Column A shows positive result and if the result is negative then it is in a column B. Column B shows negative result and if the result is positive then it is in a column A. ...
1answer
835 views

### How can I run SUMIF or COUNTIF with two Conditions?

I recently got some great help with SUMIF and COUNTIF and ended up with the following, working formulas; =SUMIF(REC!\$F:\$F,\$C2,REC!\$G:\$G) =COUNTIF(REC!\$F:\$F,\$C2) I had been mixing up the syntax and ...
1answer
902 views

### How to use countif, sumif across two sheets where the logical test is an equivalency?

I am building a simple sum sheet that relies on a conditional but I can't seem to get COUNTIF/SUMIF to work for me. To sum, I have two sheets, one with a few hundred lines of records including an ...
1answer
116 views

### How can I sum a series of tabs across tabs?

I have an excel 2007 file with 13 tabs (a summary and one for each month), and want to produce a sum up across the same cell for each month in the summary sheet. I have tried ...