I can't seem to find a reliable calculation for obtaining numerical information for three "true" conditions.

The conditions are this:

if[input date = search date]

and

if[field1 = "nc"]

and

if[field2 = "something"]

then return

the sum of fields 4 + 5

-

Right now I am having to use a script to return these results, but given the fields that the script is working in have 40 repeating cells, I don't think I'm using the cleanest solution.

Any suggestions??

Thanks

Do you mean something like

Case( field1 = "nc" and field2 = "something", field4 + field5 )

?

If all the referenced fields are repeating and the resulting calculation field is repeating, then it should return the appropriate result for each repetition.

Not exactly. There is the date factor to add in, that's where the calculation loses its ability to run correctly. There are 3 items that must be 'true' to get the info. Date=date,nc=nc,field2=something.

Do you mean something like

Case( field1 = "nc" and field2 = "something", field4 + field5 )

?

If all the referenced fields are repeating and the resulting calculation field is repeating, then it should return the appropriate result for each repetition.

Oops! What I meant was

Case( inputdate = searchdate and field1 = "nc" and field2 = "something", field4 + field5 )