CODEWITHSUNDEEP
excel
Andrius Solopovas
Andrius Solopovas

Reputation: 1057

Can Excel Multiply Multiple Numbers with one formula?

I am looking for a formula that works like sum but instead of summarysing each element I want it to multiple each lement.

For eaxample if I have the following dataset A1=1,A2=2,A3=3,A4=4 the FORMULA(A1:A4) would do the following 123*4 = 24

Is there such formula?

Thanking you in advance.

Upvotes: 0

Views: 65

Answers (1)

kalleguld
kalleguld

Reputation: 460

PRODUCT(A1:A4) is the function you need.

Upvotes: 1

Related Questions