N NV May 26, 2004 #1 I am trying to sum a range of numbers if the adjoining cells contain a certain text. How do I do that?
I am trying to sum a range of numbers if the adjoining cells contain a certain text. How do I do that?
F Frank Kabel May 26, 2004 #2 Hi try something like =SUMIF(A:A,1,B:B) sums all values in column B if column A contains a '1'
