NETWORKDAYS inside SUMPRODUCT

[SHUTTEHFACE]

Hi everyone,

I'm looking to use sumproduct, at least I think that's the right approach, to calculate total resourcing based on amount of work days per month. Here is the formula I'm using:

Please Login or Register  to view this content.

which doesn't seem to be working.

Appreciate the help. Cheers,

STF

[jeffreybrown]

Can you describe what you are trying to do? There is no explanation here.

[SHUTTEHFACE]

Hi @jeffreybrown,

I have two rows, 1 with months and the 2nd with count of resources for the month. I want to return the total number of resources multiplied by the total number of working days (only for those where there are resources scheduled). I think it will make sense if you check the excel example I attached.

Cheers,

Mike

[63falcondude]

Assuming that the expected answer is 799, I would put the working days in their own row like this:

C2 =NETWORKDAYS(C3,EOMONTH(C3,0))
Drag through N2

Then you can use this in P4:

=SUMPRODUCT(C4:N4,C2:N2)

[SHUTTEHFACE]

63falcondude,

Thanks! Is there a way to do this without adding an extra row?

Cheers

[63falcondude]

Not that I am aware of. NETWORKDAYS cannot be used with an array.