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.