Hello all...thank you in advance your help.
I am having a bit of a problem with below array:
It is working well enough in many ways. However, I need the cell that the array is in (AU) to return a blank cell if cell AV is anything but "Yes".HTML Code:
So I need I need AU to be blank if AV is anything but "Yes".
How can I modify my the above array to do that?
Thank you very much.
Eddie
Last edited by punter; 08-30-2012 at 10:46 AM.
What version of Excel are you using?
If it's Excel 2007 and up,
IFERROR(Your formula,"")
If it < Excel 2007
Maybe IF(SUMIFS(AS:AS,AV:AV,"Yes")<>0,Your formula, "")
Either of those work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you so much for your help.
I am using a new version of excel. I have tried the IFERROR but I can't get it work. Where would you put it?
HTML Code:
=IFERROR((SUMPRODUCT((AM:AM),(AS:AS), --(AV:AV="Yes")))/(SUMIFS(AS:AS,AV:AV,"Yes")),"")
I am trying the formula below:
It is still returning a value in AU even if AV has something besides "Yes". Any thoughts?HTML Code:
A value other than zero? This part of your formulashould only return values if the value in AV is Yes in any given row. Can you upload an example spreadsheet (Go Advanced> Manage Attachments)?Formula:
SUMPRODUCT(AM:AM),(AS:AS),--(AV:AV="Yes"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
punter 
Register To Reply
Bookmarks