Hello,
I have the following formula:
{=SUM(NETWORKDAYS($A$2:$B$10+0,$B$2:$C$10+0)*IF($D$2:$D$10=F2,G2:H2))}
The NETWORKDAYS formula compares two 2-column sets, and then results the product of this and a single row 2-column table.
I would like to make the IF statement's logical-test to allow for the set $D$2:$D$10 to be equal to either to F2, F3 or F4 (not just F2), with the value-if-true value equalling G2:G4 (not just G2:H2).
This resulting formula will need to refer to the possibilities F2, F3, F4 as a set, and not as individual references. I have attached the spreadsheet for your perusal.
Any help resolving this issue would be much appreciated,
-Yaddles
Bookmarks