#### NeedsHelp2

##### New Member

- Joined
- Nov 20, 2005

- Messages
- 22

The formula is below, I've had to show it this way as if I copy into the forum as a whole, it loses some of the data. I've tried

Can anyone please help as I really need to use the formula.

=IF((SUMPRODUCT(--(Sheet3!$I$4:Sheet3!$I$31="Meal Relief"),--(INDEX

(Sheet3!$T$4:Sheet3!$Z$31,0,MATCH($D12,Sheet3!$T$1:Sheet3!$Z$1,0))

="Y"),Sheet3!$H$4:Sheet3!$H$31-Sheet3!$G$4:Sheet3!$G$31+(Sheet3!

$H$4:Sheet3!$H$31<Sheet3!$G$4:Sheet3!$G$31)))+(SUMPRODUCT(--

(Sheet3!$I$4:Sheet3!$I$31="Meal Relief Whilst Vehicle Un/Loaded"),--

(INDEX(Sheet3!$T$4:Sheet3!$Z$31,0,MATCH($D12,Sheet3!$T$1:Sheet3!

$Z$1,0))="Y"),Sheet3!$H$4:Sheet3!$H$31-Sheet3!$G$4:Sheet3!$G$31+

(Sheet3!$H$4:Sheet3!$H$31<Sheet3!$G$4:Sheet3!$G$31)))=0,"",

(SUMPRODUCT(--(Sheet3!$I$4:Sheet3!$I$31="Meal Relief"),

--(INDEX(Sheet3!$T$4:Sheet3!$Z$31,0,MATCH($D12,Sheet3!$T$1:Sheet3!

$Z$1,0))="Y"),Sheet3!$H$4:Sheet3!$H$31-Sheet3!$G$4:Sheet3!$G$31+

(Sheet3!$H$4:Sheet3!$H$31<Sheet3!$G$4:Sheet3!$G$31)))+

(SUMPRODUCT(--(Sheet3!$I$4:Sheet3!$I$31="Meal Relief Whilst Vehicle

Un/Loaded"),--(INDEX(Sheet3!$T$4:Sheet3!$Z$31,0,MATCH($D12,Sheet3!

$T$1:Sheet3!$Z$1,0))="Y"),Sheet3!$H$4:Sheet3!$H$31-Sheet3!

$G$4:Sheet3!$G$31+(Sheet3!$H$4:Sheet3!$H$31<Sheet3!$G$4:Sheet3!

$G$31))))

Thanks