Forum Discussion

NicolleNeira's avatar
NicolleNeira
Copper Contributor
Dec 26, 2022

CountIFS For Linked workbook

Hello, I'm trying to bring some data using the "CountIFS" formula into linked books, but the formula seems to don't work; it returns results 0. Still, it should reflect 1+, I was reading a bit, and ...
excel
Formulas and Functions
mathetes's avatar
mathetes
Silver Contributor
Dec 26, 2022
You need to explain more fully what the column contains are that you're seeking to count. Ideally, post a copy of the workbook on OneDrive or GoogleDrive and paste a link here that grants edit access. Your current description is too brief for anybody to offer any specific advice.
  • NicolleNeira's avatar
    NicolleNeira
    Copper Contributor
    Dec 26, 2022

    mathetes 

    Thanks for the recommendation; since this is a corporate document, I cannot share it publicly, but I will try to provide more details!

    I have a Workbook with information filled by our team members ("Sourcebook"); I want that information in a different Excel book ("Destination book") for management purposes, so I created a new file to include the information entered by the team within the same shared online folder.

    When I'm trying to feed the "destination book" from "Sourcebook" with formulas such as CountIFS it returns a #VALUE error. I checked all data in the "source book" and couldn't identify any mistakes.


    I also used formulas like Sum(SumIFS, Sum(If as per microsoft community recommendations. (https://learn.microsoft.com/en-us/office/troubleshoot/excel/formula-returns-value-error)


    Thanks in advance for any help you could provide.
    Regards,

     

     

Resources