Sumproduct with four columns whereof one is criteria

[AlekNO]

Dear all,

hope someone do have extensive understanding of the sumproduct-formula.

Problem is counting cost, based on hours, currency and FTE(full time employee).

I have;
one column (C) which indicate a regular month of hours (160 normally)
one column (I) which indicate the curreny these hours have as cost base (EUR, GBP, USD etc)
one column (J) which is the actual LC (local currency) rate these hours are based in (nominal figures e.g. 100)
one column (O) which indicate the number of full time employees (1 represent one person full time one month)

in a cell below (O) i would like to calculate the column C*I*J*O, given a criteria e.g. EUR.

Im trying this;
=SUMPRODUCT(($C$38:$C$150)*(I38:I150=$N178)*(J38:J150)*(O38:O150))

But result is: #VALUE !

Cannot find any good answers to this....have so good Learning from many threads here in MrExcel, and hope there is still life in the community????

 

[Joe4]

I think what would be most helpful to us is to see some sample data and expected output.
You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.