SOLVED

Dune profile problem

Copper Contributor

• if the height at the 5 m and 10 m transect points are 10 cm and 15 cm,
respectively, the cumulative height at 10 m is 25 cm (i.e. 10 + 15 cm

 

How do I do any of this on excel please.

2 Replies
best response confirmed by SJBsarah51 (Copper Contributor)
Solution

@SJBsarah51 

See screenshot.

S1197.png

The formula in C2 is =SUM(B$2:B2)

Fill or copy this down.

Alternatively, enter =SUM(C1,B2) in C2.

Thank you so much! I'll give it a try later
1 best response

Accepted Solutions
best response confirmed by SJBsarah51 (Copper Contributor)
Solution

@SJBsarah51 

See screenshot.

S1197.png

The formula in C2 is =SUM(B$2:B2)

Fill or copy this down.

Alternatively, enter =SUM(C1,B2) in C2.

View solution in original post