Results 1 to 2 of 2

Thread: creating SUM only for cells that contain "X"

  1. #1

    creating SUM only for cells that contain "X"



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have two columns. Column A contains square footage numbers. Column B contains customer names.
    Example:
    A B
    565 Customer Acme
    44 Available Space
    23 Rosland LLC
    235 Big Corp
    552 Available Space


    How do I SUM Available Space cells?

  2. #2
    Good afternoon,

    =SUMIFS(A:A,B:B,"Available Space")

    Best of luck,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •