Ragdyer Thankyou
"Ragdyer" wrote:
This works for me:
=SUMPRODUCT(($A$4:$A$109=1)*($B$4:$B$109="P")*D4:G 109)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steved" wrote in message
...
Hello from Steved
Below is fine for D4:D109 but if I change it to D4:G109 it shows #VALUE!
My objective is to sum the extra 3 columns.
What is required please to have it working.
=SUMPRODUCT(--('Planned Kilometres'!$A$4:$A$109=1),--('Planned
Kilometres'!$B$4:$B$109="P"),'Planned Kilometres'!D4:D109)
Thankyou.
|