I've tried searching the board but couldn't find anything. (or maybe I couldn't understand what I found!)
I'm trying to add up hours for employess in a spread sheet based on name, work type (regular, Overtime, etc) , and month. So, I have three array conditions and one to add up.
A B C D
1joe OT 1 8
2joe RE 2 8
3jim RE 1 12
4jim OT 1 8
I tried sum(if(and(A1:A4="joe",B1:B4="OT",C1:C4=1),D1:D4))
any ideas?
I'm trying to add up hours for employess in a spread sheet based on name, work type (regular, Overtime, etc) , and month. So, I have three array conditions and one to add up.
A B C D
1joe OT 1 8
2joe RE 2 8
3jim RE 1 12
4jim OT 1 8
I tried sum(if(and(A1:A4="joe",B1:B4="OT",C1:C4=1),D1:D4))
any ideas?