Skip to Content

Subtotals based on if statement

I have got the following data

Product group Amount

Pipe. 50

Fittings. 40

Brick. 20

Mortar. 30

Elbow. 15

Additional fit. 55

I need to add totals for 3 groups A pipe,fittings,elbow B brick mortar C add fittings. So I put an if statement with then sum in the footer and it works ok for group C only. Always just the last line of my data. Please help

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers