| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
{SUM(IF((ARRRAY FORMULA)}
Hi
I use this formula a lot. My question is, is it possible to use it with dates either by actually entering a date as below or referencing the date to a cell? So far I can't get anything with dates to work. eg {(sum(if(($a$1:$a$50=9/10/07)*($b1:$b2<250),$c1:$c50)} -- bookman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set a 2D arrray data into a range, given the top-left cell | Excel Discussion (Misc queries) | |||
Threaded Mode
