J
Jay
Hi,
I'm using the following formula but it's not working because my SUM
range E29:E59 contains #N/As. I know one solution is to add an IF
statement to the formulas in E29:E59 to return "" if not avialable but
I'm trying to find a olution that works *with* the NAs is the range.
=SUMPRODUCT(--(B29:B59>=B94),--(B29:B59<=C94),(E29:E59))
In any other array formula I'd try use IF and ISNUMBER but am not sure
if this is possible with Sumproduct.
Can anyone advise how I can amend this formula so that it works with
#N/As in E29:E59. Or, another forumla that does the same thing?
Many thanks,
Jason
I'm using the following formula but it's not working because my SUM
range E29:E59 contains #N/As. I know one solution is to add an IF
statement to the formulas in E29:E59 to return "" if not avialable but
I'm trying to find a olution that works *with* the NAs is the range.
=SUMPRODUCT(--(B29:B59>=B94),--(B29:B59<=C94),(E29:E59))
In any other array formula I'd try use IF and ISNUMBER but am not sure
if this is possible with Sumproduct.
Can anyone advise how I can amend this formula so that it works with
#N/As in E29:E59. Or, another forumla that does the same thing?
Many thanks,
Jason