Array formula
I'm still getting the #NUM. I was wondering if formatting could have
anything to do with it. I know when I'm using lookup formulas the format is one area I usually look at but I can't seem to find anything with this. Thanks for your assistance. -- Constance "Pete" wrote: I think your original formula should be: =sum(IF(((name=a2)*(dept=b2)*(earn_code=c2)),hours ,0)) type this in then press CTRL SHIFT and ENTER at the same time - the curly brackets will be added automatically. Pete |
All times are GMT +1. The time now is 01:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com