| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function needed????
very elegant biff
-- paul remove nospam for email addy! "Biff" wrote: Why not just count the the cells that are 0 <14 and multiply by 150? =SUMPRODUCT((A1:B200)*(A1:B20<14))*150 Biff "paul" wrote in message ... if i have understood correctly for each row(this for row 1 and copy down) =IF(AND(A1=1,A1<14),150,0)+IF(AND(B1=1,B1<14),15 0,0) -- paul remove nospam for email addy! "prbucci" wrote: Sorry I didnt pay attention to the last post. My reply to your question is; in the row each cell needs to add up to 14 or more indivdually not the total row. Back to my last reply though, it needs to be less then 14 but more then -0- -- prbucci ------------------------------------------------------------------------ prbucci's Profile: http://www.excelforum.com/member.php...o&userid=30428 View this thread: http://www.excelforum.com/showthread...hreadid=501425 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DAverage Function help needed | Excel Worksheet Functions | |||
| Desperate Help needed with a function. | Excel Worksheet Functions | |||
| function needed | Excel Worksheet Functions | |||
| IF function help needed | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
