Sum formula
In table format code hrs code hrs code hrs total 10 8 20 8 42 10 16 12 6 11 1 40 8 15 I need to sum the hrs if the code does not equal 42. What is the best way to accomplish task? -- Bonita |
Sum formula
Sorry for the duplication
-- Bonita "Bonita" wrote: In table format code hrs code hrs code hrs total 10 8 20 8 42 10 16 12 6 11 1 40 8 15 I need to sum the hrs if the code does not equal 42. What is the best way to accomplish task? -- Bonita |
Sum formula
Try this in G2 and copy down as needed:
=SUMPRODUCT((MOD(COLUMN(A2:E2)+1,2)=0)*(A2:E2<42) *B2:F2) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Bonita" wrote in message ... Sorry for the duplication -- Bonita "Bonita" wrote: In table format code hrs code hrs code hrs total 10 8 20 8 42 10 16 12 6 11 1 40 8 15 I need to sum the hrs if the code does not equal 42. What is the best way to accomplish task? -- Bonita |
All times are GMT +1. The time now is 06:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com