Assume that C2 will *always* be larger then D2:

=COUNTIF(E2:J2,"w")*(C2-D2)+D2*6
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"enna49" wrote in message
...
Hi
I have used the formula below for adding across cells if certain criteria.
This does work, however is there a cleaner way of doing this. Example
Data
below:

C2 = Working Shift Cost
D2 = Idle Shift Cost
E2 to J2 represents days of the week (Mon - Sat) and a Total is required
for
this cost. Using Excel 2007


=SUM(IF(E2="W",C2,D2)+(IF(F2="w",C2,D2))+(IF(G2="w ",C2,D2))+(IF(H2="w",C2,D2
))+(IF(I2="w",C2,D2))+(IF(J2="w",C2,D2)))
Thanking you
Anne