HI
I want to calculate 3 colums. In A2:A100 the employenr, In H2:H100 the period, In K2:k100 Chargable hours.
I.E: Sum Chargable hours when employenr is 100, and period is 2.
I tried this formula but only get #name.
=SUMPRODUCT((A2:A100=100)*(H2:H100=2)*(K2:K100))
Thanks for any help
I'm not sure why you get the #NAME error...if you spelled SUMPRODUCT correctly and there are no other #NAME errors in your data....
but try this: =SUMPRODUCT((A2:A100=100)*(H2:H100=2),(K2:K100))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Tried your suggestion, but sorry it did not work. Is there any problem that the employenr is a mix of numbers and letters? Eks employenr is NB10017.
The formula works fine with to criteria i.e:
=SUMPRODUCT((H2:H100=2)*(K2:K100))
That should be no problem...you must have a #NAME error in column A.....
But are you looking for employeenr containing the number 100?
if so, the formula should be:
if still a problem, post your zipped file here....
Please Login or Register to view this content.
Now it works! I had to set the employeenr in "" in the formula.
I do not need to find empl. nr contains 100. The empl.nr is always unique.
i.e: NO010078
=SUMPRODUCT((A2:A100="NO010078")*(H2:H100=2),(K2:K100))
Thanks for great help!
Elad
Norway
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks