ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Array formula (https://www.excelbanter.com/excel-discussion-misc-queries/61276-re-array-formula.html)

Constance

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