I have 2 formulas that work by themselves, BUT need them to merge together into one formula (keep getting errors). Just trying to say if the cell I'm referencing in Column D contains the word "REGION" then do not return a value from it. Otherwise if it IS in the pivot table I am referencing then needs to say "Strategic"
=IF(COUNTIF(Master_4.21!H$5:$H$43,D14),"Strategic","")
=IF(SUM(COUNTIF(D14,{"*REGION*"})),"")
Thanks in advance!!!!
Try this:
=IF(COUNTIF(D14,"*REGION*"),"",IF(COUNTIF(Master_4.21!H$5:$H$43,D14),"Strategic",""))
Hope this helps.
Pete
or perhaps just...
=IF(D14="*REGION*","",IF(COUNTIF(Master_4.21!H$5:$H$43,D14),"Strategic",""))
In the 2nd countif, it looks like you are just testing to see if the contents of D14 are anywhere in that range, no matter how many times? If so, you could also use MATCH()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Just a tip, you can have a maximum of 7 'IF' Functions in one formula. You won't get any errors, after 7 it just won't work. I found this after much trial & error, hope this might save you some.
Remember you are unique, like everyone else
Not any more - you must have an old version of Excel! From Excel 2007 it went up to 64.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Good to know AliGW, It was a long time ago but I still remember how frustrating it was to work that one out... Btw, I'm trying to post a thread & I get an error like a Firewall not letting me post?? I wondered if anything had changed at Excel Forum? Thanks again. Peter
The firewall kicks in if it thinks you are trying to post some HTML code.
The angle brackets < and > are used to indicate this, and you could inadvertently have this in a formula where you mean not equal to - you have to remember to include a space immediately before and after those symbols.
Hope this helps.
Pete
This worked - thank you!!!
Glad to hear it - thanks for the rep.
Pete
Attachment 677328
can anyone help with this ?
i need the right formula to total amount following by date.
You should start your own new thread rather than hijack someone else's (see Rule 04 at the top of the screen).
Pete
okay sorry.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks