Array formula
 

Your error is being caused by multiplying text..."name=a2*dept=b2". You may
want to combine some of these data points in another column using "&", the do
a SUMIF based on the combined column.

"Constance" wrote:

I seem to be having a problem with an array formula. I have a spreadsheet
with names in one column, home department numbers in column B, earning codes
in column C, worked dept in column D and hours in column E. I'm trying to
sum only one type of earning code for each employee for the home dept so I'm
using this formula: {=sum((name=a2)*(dept=b2)*(earn_code=c2)*hours)} and all
I get is #NUM. I can't figure out what I am missing. Can anyone guide me?
Thanks.
--
Constance

Array formula
 

That works! Thanks much.
--
Constance


"JR" wrote:

Your error is being caused by multiplying text..."name=a2*dept=b2". You may
want to combine some of these data points in another column using "&", the do
a SUMIF based on the combined column.

"Constance" wrote:

I seem to be having a problem with an array formula. I have a spreadsheet
with names in one column, home department numbers in column B, earning codes
in column C, worked dept in column D and hours in column E. I'm trying to
sum only one type of earning code for each employee for the home dept so I'm
using this formula: {=sum((name=a2)*(dept=b2)*(earn_code=c2)*hours)} and all
I get is #NUM. I can't figure out what I am missing. Can anyone guide me?
Thanks.
--
Constance