Function help!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=IF(B11<>"",SUMIF(Events!A10:A311,Events!B10:C10,">="&('General log'!Y11:Z11),Events!N10:N311),""

In the function above I trying to reference a date and time field in Events!B10(Date):C10(Time) that is equal to or greater than the date and time field in General Log!Y11(Date):Z11(Time) and show only values that meet that criteria from Events!N10:N311. (B11 is the Item number that ties related records back together in the end.

The formula layout has the right idea, but, fails to deliver the correct results. Re -arrange the formula as needed to correct it. Please help!!

Thanks,......
 
Hi
not really sure what you're trying to compare but maybe the following
is what you want. Better would be if you could post some example rows
(plain text - no attachment please):
=IF(B11<>"",SUMPRODUCT(--(Events!B10:B311+Events!C10:C311>='General
log'!Y11 + 'General log'!Z11), Events!N10:N311),"")


I wasn't sure what you're trying to do with column A
 
Column Events!A10:A310 is equal to B10:B61 on the Main Worksheet and contains the Item number that links the record back to the main worksheet. So, they must be left in or as part of the function

----- Frank Kabel wrote: ----

H
not really sure what you're trying to compare but maybe the followin
is what you want. Better would be if you could post some example row
(plain text - no attachment please)
=IF(B11<>"",SUMPRODUCT(--(Events!B10:B311+Events!C10:C311>='Genera
log'!Y11 + 'General log'!Z11), Events!N10:N311),""


I wasn't sure what you're trying to do with column

-
Regard
Frank Kabe
Frankfurt, German


Syd wrote
 
Hi Syd
I'm not sure what you're trying to do. Could you please post some
example data (as plain text)
 
Frank

All I need to do is pull values from the Secondary (Event) sheet Column B and C if the date and time is equal to or greater than column Y and Z on the Main WorkShee

Here they are: Main WorkShee
B V W X Y Z A
2400107 02/01/04 7:00 456434 02/01/04 8:45 45643
2400131 02/05/04 16:45 458588 02/05/04 17:20 45858
2400141 02/09/04 10:30 460820 02/13/04 9:10 46082
2400160 02/16/04 8:00 463511 02/16/04 8:40 46351
2400183 02/25/04 9:20 465572 02/25/04 9:20 46557

Secondary(Events) Worksheet
A B C D E F G
2400141 02/11/04 8:15 461120 02/11/04 9:00 46114
2400141 02/11/04 7:10 462180 02/13/04 7:55 46218
2400141 02/13/04 9:05 462180 02/13/04 9:10 46218
2400141 02/13/04 10:00 462227 02/13/04 10:25 46222
2400141 02/13/04 10:25 462227 02/13/04 10:35 46222

Hope this helps.....

----- Frank Kabel wrote: ----

Hi Sy
I'm not sure what you're trying to do. Could you please post som
example data (as plain text

-
Regard
Frank Kabe
Frankfurt, German


Syd wrote
 
Hi Syd
sou you want for each row in the worksheet the sum from column N of the
event sheet?. If yes put the following formula in the first row (I
assumed row 11) of your main worksheet


=IF(B11<>"",SUMPRODUCT((Events!$A$10:$A$311=B11)*(Events!$B$10:$B$311+E
vents!$C$10:$C$311>='Generallog'!Y11 + 'General log'!Z11),
Events!$N$10:$N$311),"")
and copy this down
 
Back
Top