I need to Sum the value D2:G1000
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. |
I need to Sum the value D2:G1000
=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. |
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. |
All times are GMT +1. The time now is 08:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com