using if for multiple criteria
Thank you for your quick response, this is great.
Please can you help in another issue that has arisen with the same scenario.
There is now an extra field required eg BREAKDOWN, how can I include this to
be another option.
I have also tried to fix the N/A option. If you know of a quick solution
that would also be helpful.
Thanking you
"Ragdyer" wrote:
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
|