You don't need to explicitly test for True. Use the fact that True=1 and
False=0 (on Excel worksheets anyway);
=SUMPRODUCT(A1:A9*B1:B9*C1:C9)
NickHK
"kayard" wrote in
message ...
Hi, I'm back again asking for some help.
I have in column A and B 2 formulas that evaluate to either true or
false. In column C I have a number. Say that I have 1000 rows; i want
to sum only those values in column C where valuels in column A and B
in the same row are both true.
Of course I can create a new column D where I AND booleans in A and B
but This would make me create a new column ... I do not want this
because in my file I have many many pairs of A & B. So I would have to
create at least 25 more columns containing AND formulas...
I need something that doesn't oblige me to create any new column
Thanks in advance for any help
Sorry for my english, I hope I have made myself understood.
Paolo
Italy
--
kayard
------------------------------------------------------------------------
kayard's Profile:
http://www.excelforum.com/member.php...o&userid=24716
View this thread: http://www.excelforum.com/showthread...hreadid=569507