6 replies
by dklippert
There's a very good discussion of this problem at:
http://www.cpearson.com/excel/array.htm
(there are no spaces in the URL)
by sankulpune
Hello dbaker,
If you want to sum the column 'C' (say c1:c10 with data in A1:A10 and B1:B10) when even a single pair of 1 & A is found in columns 'A' and 'B', type the following formula in C11:
=IF((SUM(IF(A1:A5=1, IF(B1:B5="A",1,0))))>0, SUM(C1:C10))
You need to convert it into an array formula by pressing CTRL+SHIFT+ENTER instead of just ENTER after typing the formula in the cell.
SanganakSakha,
Simple And Effective Solutions To Small Problems, No QuickFixes.
by dbaker
The formula worked - after I made an array formula out of it by pressing CTRL+SHIFT+ENTER
Thanks
by dbaker
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending