Difficult (for me) question about conditional SUM
- From: kayard <kayard.2c8bzr_1155054311.595@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 8 Aug 2006 12:21:50 -0400
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?action=getinfo&userid=24716
View this thread: http://www.excelforum.com/showthread.php?threadid=569507
.
- Follow-Ups:
- Re: Difficult (for me) question about conditional SUM
- From: kayard
- Re: Difficult (for me) question about conditional SUM
- From: NickHK
- Re: Difficult (for me) question about conditional SUM
- From: Conan Kelly
- Re: Difficult (for me) question about conditional SUM
- Prev by Date: Re: Get RGB settings
- Next by Date: Re: Get RGB settings
- Previous by thread: If IsNumber or IsNumeric
- Next by thread: Re: Difficult (for me) question about conditional SUM
- Index(es):
Relevant Pages
|
