creating SUM only for cells that contain "X"

1boredguy

New member
Joined
Feb 28, 2012
Messages
8
Reaction score
0
Points
0
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?
 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
Good afternoon,

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

Best of luck,
 
Top