Hello From Steved

below starts at A4:G15 Column A is place, Colum B is Product I need to sum
D4:D15
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.

Did you check your first post?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steved" wrote in message
...
Hello From Steved

below starts at A4:G15 Column A is place, Colum B is Product I need to sum
D4:D15
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.

Hi!

Try this:

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

Biff

"Steved" wrote in message
...
Hello From Steved

below starts at A4:G15 Column A is place, Colum B is Product I need to sum
D4:D15
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 I was posting it as you were posting your Answer

And Thankyou again.

"Ragdyer" wrote:

Did you check your first post?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steved" wrote in message
...
Hello From Steved

below starts at A4:G15 Column A is place, Colum B is Product I need to sum
D4:D15
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.

Thankyou Biff.

"Biff" wrote:

Hi!

Try this:

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

Biff

"Steved" wrote in message
...
Hello From Steved

below starts at A4:G15 Column A is place, Colum B is Product I need to sum
D4:D15
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.

[fergie]

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


"Steved" wrote:

Hello From Steved

below starts at A4:G15 Column A is place, Colum B is Product I need to sum
D4:D15
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.

[MartinW]

Hi Fergie,

Goto ToolsOptionsGeneral tab and uncheck
R1C1 reference style.

HTH
Martin