=ROUNDUP((SUMIF(Bldg_Program[Floor],C43,Bldg_Program[Total NSF]))*1.05,-2)

http://www.modifiedlife.com/2000-mercedes-c43-amg-car-stereo-wire-schematic/

you mean it was not working now?

My guess is that you meant Siemens instead of Siemans. Is that correct?

Main office:
37th Floor Robinsons Summit Center
6783 Ayala Avenue
Makati City, Philippines
Trunk Line: (632) 888-5900
Fax Line: 830-7300
8:30am to 5:30pm / Monday to Friday

14th Floor San Miguel Properties Center St.
Francis Street
Ortigas Center Mandaluyong City
1600 Philippines
Trunk Line: (632) 667-4111
Fax Line: (632) 667-4005

HP Service Centers:
GF Accelerando Building,
395 Sen. Gil Puyat Avenue, Makati City
Tel. No. (632) 888-6100

Unit C-D-E Ground Floor
Capitol Centrum Bldg.
Clavano cor. Escario St. Cebu City
Tel. No. (032) 254-4548 or (032) 412-5300

I just fixed this take out the 3 screws out at the floor and pull off the front cover and unscrew the cap to the strainer and clean out ..this takes about15 minutes total..heres the book the trap is in the pic on the lower right


https://secured.whirlpool.com/Service/SrvTechAdm.nsf/2cd44500d572193285256a45004fd9d6/6545d78b3f479480852571650061b1ba/$FILE/8178558.pdf

Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

BTW, sent you a similar email about this.

One in general should not use Find & Replace.
I would recommend always creating the first formula manually by selecting the cells. This will avoid common errors like extra spaces.

Try using the SUMIF function for one condition or multiple conditions. Use the SUMIF worksheet function to create a total value for one range based on a value in another range. For example, for every cell in the rage B5:B25 that contains the value "Northwind", the following formula calculates the total for the corresponding cells in the range F5:F25. Formula:
=sumif(B5:B25,"Northwind",F5:F25)

Here are SUMIF functions for multiple conditions.

=sum(if((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

=sum(if((B5:B25="Northwind")+(C5:C25="Western"),F5:F25))

=sum(if(B5:B25="Northwind",IF(C5:C25="Western"),1,0)))

Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

try using the formula "sumif". It allows you to sum by category/name. Good luck! D.