I am having a problem with this function. If someone has a fix for the following formula, I would really appreciate their input.
=AVERAGEIFS(BeezidTable[final],BeezidTable[retail],A2,BeezidTable[WkNum],WEEKDAY(TODAY()),BeezidTable[TimeNum],">g1")
There is data that meets the criteria, but it evaluates to #div/0!.
Thanks
Re: TimeNum - are you looking for the literal string "g1" or does g1 hold a value you wish to reference ?
If the latter then the syntax would be:
BeezidTable[TimeNum],">"&G1
You might want / need to post a sample
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
G1 holds a timevalue I want to reference. Does that help? Thanks
On which basis - did you change the syntax as advised in prior post ?
If so, what was the end result ?
Yes, seemed to work - I just wanted to make sure it was picking up the value, not the text string. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks