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
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