Hello - I have a sheet where one of my column is labeled Status and then I have another column for dollar amounts called Extended. What I am trying to do is check to see if any information at all (non blank) has been entered in the Status column, and if it has, then I want to sum only the Extended values that are adjacent to information in the Status column
Ex.
Status Extended
A Keep $3000.00
B Not Needed $2500.00
C $1500.00
D Keep $4000.00
E $500.00
Figure I am looking for Would Yield - $9500.00
Thanks in advance for your help.
Bookmarks