Subtotal

[Steved]

Hello from Steved

=SUBTOTAL(($D$2:$D$2000="CITY DEPOT")*9,$B$2:$B$2000)

I have 7 Names for example City, Roskill and so on and each name has 20
products

My question please is That I just want to add City Depot and its products,
but it adds up the whole Column, What is needed to change in the above
formula to give me subtotal off City Depot and products.
Thankyou

 

[bpeltzer]

If I'm interpreting correctly, I think you just want
=sumif($D$2:$D$2000,"CITY DEPOT",$B$2:$B$2000).
That is, look for "CITY DEPOT" in column D and return the sum of the
corresponding cells in column B.

 

[Steved]

Yes

And I thankyou.

If I'm interpreting correctly, I think you just want
=sumif($D$2:$D$2000,"CITY DEPOT",$B$2:$B$2000).
That is, look for "CITY DEPOT" in column D and return the sum of the
corresponding cells in column B.