Hello. I need to create a formula to sum if two criteria are met, AND for multiple responses. More specifically, I need to get the total if column F says "October 2019" and if column K says "Declined", "Customized", or "Standard." The productivity tab in on another sheet in the spreadsheet. Hopefully that makes sense. Any help or pointing me in the right direction would be appreciated.
Look at using the =countifs function. Here is a link to the syntax
https://www.techonthenet.com/excel/f...s/countifs.php
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Alan, I figured it was COUNTIF. But I can't figure out the exact formula. The formula below is not working for me.
=COUNTIFS(Referrals!K:K, "Declined", Referrals!F:F, "October 2019")+COUNTIFS(Referrals!K:K, "Customized", Referrals!F:F, "October 2019")+COUNTIFS(Referrals!K:K, "Standard", Referrals!F:F, "October 2019")
I don't access to Excel to test this, but give it a try.
=countifs(Referrals!f:F,"October 2019,referalls!K:K,{"Customized","Declined","Standard"})
Alan, thank you for your reply. It seemed to be only counting the "Customized" but not the other options from the drop down list.
Can anyone else help me with this?
It would help if you attached a sample Excel workbook.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Do not try to use the Paperclip icon, as this does not work on this forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks