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.

=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.

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.