Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
1.) I want excel to search down a column and identify the status “Completed.”
2.) After it finds all instances, I want it to go to the next column (this is a number column) in the same rows as the “Completed” status appear
3.) I want Excel to sum all the numbers in this column. Note that it should only be summing numbers that had the status marked as “Completed”
Example:
Column A Column B
Completed 4
In Process 3
Completed 2
In Summary:
I would want a function that will recognize “Completed”, pull the numbers from a separate column, and sum these. So in my example the correct output in 6 (4+2) Read More