I still need help with formular?
 

SUMIF is not working I think I need to combine 2 formulars together

Heres what I have now using sumif

I have one worksheet called weekly wage this is where I want to enter in my
payslips each week

at the top I have a cell for placing which state I am working in at the time
I would be entering the pay slip info
I have my reg time pay cell and over time cell and then I also have all the
deductions the usual for a payslip

I have another page called state totals this is where I want my gross totals
to be entered for the corrisponding state
I am using sumif as advised it worked fine so long as I stayed in that state
for example alabama but as soon as I went to enter in the info for example
virginia all the info in alabama was removed and the info for virginia was
entered

here is the formuler I am using

=SUMIF('Wage Entry'!G5:H5,"Alabama",'Wage Entry'!M4:N5)
=SUMIF('Wage Entry'!G5:H5,"Virginia",'Wage Entry'!M4:N5)
Please tell me I dont need to create a new wage entry page for each state
for this to work?
there should be some way to do this I am sure can some one help?

I still need help with formular?
 

Buzz

Have 2 seperate cells to handle each of the formulas.

On your "State_Totals" page.

Alabama Cell(Assume A1)

=SUMIF('Wage Entry'!G5:H5,"Alabama",'Wage Entry'!M4:N5)

Virginia Cell(Assume A2)

=SUMIF('Wage Entry'!G5:H5,"Virginia",'Wage Entry'!M4:N5)

Total Cell(Assume A3)

=Sum(A1:A2)

HTH
Mark.

I still need help with formular?
 

Ok I dont understand You Mean I need to have seporate cell for each state
and there is no way or formular that can retain the info cause that would
mean I would have to have a seporate wage info sheet for each state and I
work out of all of them through a year I repair power stations across
america and some of canada that is just too much I thought for sure there
would be an easier way
"NoodNutt" wrote in message
...
Buzz

Have 2 seperate cells to handle each of the formulas.

On your "State_Totals" page.

Alabama Cell(Assume A1)

=SUMIF('Wage Entry'!G5:H5,"Alabama",'Wage Entry'!M4:N5)

Virginia Cell(Assume A2)

=SUMIF('Wage Entry'!G5:H5,"Virginia",'Wage Entry'!M4:N5)

Total Cell(Assume A3)

=Sum(A1:A2)

HTH
Mark.