How do I please.

[Steved]

Hello From Steved

below starts at A4:G15 Column A is place, Colum B is Product I need to sum
D415
I need a total for product P how do I do this Please

A B C D E
F G
1 P 5982 5982 5982 5982
1 P 13154 13154 13154 13155
1 S 258 258 258 258
1 P 13154 13154 13154 13155
1 S 258 258 258 258
1 P 13154 13154 13154 13155
1 S 272 272 272 272
1 P 13154 13154 13154 13155
1 S 258 258 258 258
1 P 13204 13204 13204 13204
1 S 258 258 258 258
1 P 7767 7767 7767 7767

Thankyou.

 

[Ragdyer]

Did you check your first post?

 

[Biff]

Hi!

Try this:

=SUMPRODUCT((B4:B15="P")*D4:G15)

Biff

 

[Steved]

Ragdyer I was posting it as you were posting your Answer

And Thankyou again.

 

[Steved]

Thankyou Biff.

Hi!

Try this:

=SUMPRODUCT((B4:B15="P")*D4:G15)

Biff

 

[fergie]

the colums are numbered same as rows
how do I change them to letters?

 

[MartinW]

Hi Fergie,

Goto Tools>Options>General tab and uncheck
R1C1 reference style.

HTH
Martin