Function Question

  • Thread starter Thread starter SteveF
  • Start date Start date
S

SteveF

I have 2 columns (Col1 and col2) of data

eg

Col1 Col2
10 Archive
42 N/a
56 Ignore
444 Archive
55 N/a
666 N/a

What would be the function which would sum all of column1 for the value
in column 2 is equal to "Archive"?

The answer for above would be: 454
Thanks in advance

Regards

Steve Fisher
 
You must log in or register to reply here.

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

Sum cells in columns based on condition 5
Update datarow 2
SUMPRODUCT Function Compare Date 3
Merging row data in Column A has duplicate. 1
return 2 or more variables from a function 3
column to row 4
Sumif based within non blank cells 3
lookup function with 2 parameter in VBA ? 5

Back
Top