Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Difficult ------------- question | Excel Discussion (Misc queries) | |||
difficult question | Excel Discussion (Misc queries) | |||
Difficult Question | Excel Programming | |||
Another very difficult question; sorry! | Excel Programming | |||
A difficult question | Excel Programming |