I know there is a million examples on the board of how these work, and have tested a number of them, but I can't seem to get it to work on my sheet.
The formula I have at the moment is
Sheet2 E5 is a date, the data in B2:B5000 are dates
H2:H5000 either has OTE or #N/A from a lookup
G2:G5000 are the values I wish to sum
I am using CSE to enter the formula.
I am getting #N/A as the result in the cell.
Can anyone point out any stupid things I am missing or stuffed up on?
Many thanks
The formula I have at the moment is
Code:
{=SUMPRODUCT(--(WORK_TRANSACTIONS!B2:B5000=Sheet2!E5),--(WORK_TRANSACTIONS!H2:H5000="OTE"),--(WORK_TRANSACTIONS!G2:G5000))}
Sheet2 E5 is a date, the data in B2:B5000 are dates
H2:H5000 either has OTE or #N/A from a lookup
G2:G5000 are the values I wish to sum
I am using CSE to enter the formula.
I am getting #N/A as the result in the cell.
Can anyone point out any stupid things I am missing or stuffed up on?
Many thanks