I'm hoping this is really basic - I'm having a moment!
This is what my issue is:
Cell a1 could have values of Jobs, Tickets, Items or Packets.
The rest of the column is filled with values of 0, 0.5 or 1 (no blanks).
What formula do I need that gives me a total of the values if a1 is Jobs?
Can I do a sum within an if statement or similar?
This is what my issue is:
Cell a1 could have values of Jobs, Tickets, Items or Packets.
The rest of the column is filled with values of 0, 0.5 or 1 (no blanks).
What formula do I need that gives me a total of the values if a1 is Jobs?
Can I do a sum within an if statement or similar?