How do I please.
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. |
How do I please.
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. |
How do I please.
Hi Fergie,
Goto ToolsOptionsGeneral tab and uncheck R1C1 reference style. HTH Martin |
All times are GMT +1. The time now is 09:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com