- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Formula help
Posted on 10/11/16 at 8:23 pm
Posted on 10/11/16 at 8:23 pm
I'm trying to use a COUNTIFS formula to check some data.
So essentially if Column D has anything in it and Column A is blank, I need to be aware of it.
I figured a COUNTIFS would tell me how many instances this occurred so I could know to go look for them.
So essentially if Column D has anything in it and Column A is blank, I need to be aware of it.
I figured a COUNTIFS would tell me how many instances this occurred so I could know to go look for them.
Posted on 10/11/16 at 9:14 pm to southernelite
Of you're just trying to find those lines, it might be better to filter the data. Blanks and non-blanks are choices on the pulldown menu so you can choose blanks for A and non for D.
Posted on 10/11/16 at 9:29 pm to Bullfrog
quote:nah, countifs in this case, however as stated above sorting it is probably the easiest way to go
Check out sumifs
Posted on 10/11/16 at 9:35 pm to Bestbank Tiger
Yeah, just really trying to avoid any extra steps that aren't necessary. I may just add another two columns and go run isblanks in both and then write the COUNTIFS c is true, f is false. but was hoping I could write the isblanks into the COUNTIFS formula
Eta: I already have sumifs predicated on A, which is a vlookup to D, which are ticker symbols. But if a new stock appears, it won't render a value to A, which throws my report off.
Eta: I already have sumifs predicated on A, which is a vlookup to D, which are ticker symbols. But if a new stock appears, it won't render a value to A, which throws my report off.
This post was edited on 10/11/16 at 9:37 pm
Posted on 10/11/16 at 9:46 pm to southernelite
Not sure if this helps, but here is one way...
Posted on 10/12/16 at 6:07 am to southernelite
Are you putting the formula on every row or attempting the summarize the data?
If you are checking to see if each row meets a criteria you should just use a IF statement with an AND clause for the logic.
If you are checking to see if each row meets a criteria you should just use a IF statement with an AND clause for the logic.
Popular
Back to top
Follow TigerDroppings for LSU Football News