=SUMIF(B1:B3,"<",A1:A3)
Daniel Wrote:
How do I return a sum of a range of cells corresponding to a certain
criteria
(For example: I want the sum of all cells in A column which have a
value in
B colomn:
A B
1 A
3 B
6
- I only want the sum of cells a1, a2 = 4)
Thanks.
--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=319037