LinkBack URL
About LinkBacks
In the screenshot attachment you can see 3 columns in my spreadsheet. I want to calculate the average in column B ONLY if Column A contains "GroupTweet".
This is possible right? Thank you for any and all help!
In the screenshot attachment you can see 3 columns in my spreadsheet. I want to calculate the average in column B ONLY if Column A contains "GroupTweet".
This is possible right? Thank you for any and all help!
Last edited by yettie10ff; 08-08-2017 at 06:07 PM.
Formula:
Please Login or Register to view this content.
BSB
Awesome, thanks! Worked perfect.
Glad to help
BSB
Shoot - just realized I might want the criteria to be true for two separate columns like screenshot below. Any way to use formula only to average if GroupTweet & New?
I can concatenate those two columns, but would help speed things up if I didn't have to do that for each spreadsheet I'm analyzing.
No problem, you can use AVERAGEIFS for multiple criteria.
Formula:Please Login or Register to view this content.
BSB
Awesome. Thanks!
No probs.
Don't forget to mark the thread as SOLVED if you're happy you have a working solution.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks