View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved
 
Posts: n/a
Default 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.