I need to Sum the value D2:G1000
Thankyou very much.
"Bob Phillips" wrote:
=SUMPRODUCT(($C$2:$C$1000="City Depot")*(D$2:G$1000))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Steved" wrote in message
...
Hello from Steved
Below is a formuls for 4 periods I've done the below but ned to add col
D2:G1000
I'got it to work for Column D But when I add In D2:G1000 it is only adding
D
Column
What is require to sum The value D2:G1000 Please.
=SUMIF($C$2:$C$1000,"City Depot",D$2:D$1000)
Thankyou.
|