Add cells in column depending on value of cells in another column

G

Guest

One column has the status (open or closed). Another column has a $ amount.
I want to be able to sort on any column and still have a total of each
status. I tried =Sum(G2:G358)*If(F2:F358, "Open") - but that did not work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex Question on Filtering on a merged column 1
Subtract then Add Results 5
Counting Cells in a column depending on another column but excluding duplicates 2
Average cells based on column header 6
Checking status of issues based on first two digits of a field 7
How to auto add data based on value in another column 5
select a column, then add rows of each column 3
Excel Subtracting multiple columns from another column 3

Top