ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how many condition for conditional sum wizard ? (https://www.excelbanter.com/excel-worksheet-functions/27257-how-many-condition-conditional-sum-wizard.html)

Mostafa Niazy

how many condition for conditional sum wizard ?
 
I have used the conditional sum wizard for many times , but i found that if
you give
it mare than 4 conditions and the database in a differnet sheet , after you
finish
and press Enter you found the cell is blank with no error

Bob Phillips

Conditional formatting only supports 3 conditions (+ 1 for the default,
anything else).

If you need more, check out Take a look at this site:
http://xldynamic.com/source/xld.CFPlus.Download.html


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mostafa Niazy" <Mostafa wrote in message
...
I have used the conditional sum wizard for many times , but i found that

if
you give
it mare than 4 conditions and the database in a differnet sheet , after

you
finish
and press Enter you found the cell is blank with no error





All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com