I need to Sum the value D2:G1000

[Steved]

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$1000)

Thankyou.

 

[Bob Phillips]

=SUMPRODUCT(($C$2:$C$1000="City Depot")*(D$2:G$1000))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Steved]

Thankyou very much.

=SUMPRODUCT(($C$2:$C$1000="City Depot")*(D$2:G$1000))

--

HTH

RP
(remove nothere from the email address if mailing direct)