Need help creating a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3527733%22%20slang%3D%22en-US%22%3ENeed%20help%20creating%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3527733%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20some%20help%20creating%20a%20formula%20(not%20that%20good%20at%20excel%20at%20the%20moment).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESection%20A%3A%3C%2FP%3E%3CP%3EIn%20the%20transfer%20section%20I%20need%20a%20formula%20(I%20think%20a%20countifs%20one)%20that%20will%20see%20the%20information%20in%20section%20B%20and%20give%20a%20total%20count%20for%20cells%20that%20have%20the%20same%20date%20as%20Section%20A%20as%20well%20as%20Transfer%20(so%20it%20would%20filter%20out%20data%20that%20is%20on%20other%20days%2C%20even%20if%20they%20have%20transfer)%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%3EDate%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3ETransfer%20%23%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E%3CP%3E6%2F19%2F2022%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3E%3CP%3E%26lt%3B----%20this%20is%20where%20formula%20would%20be%20needed%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E6%2F20%2F2022%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E6%2F21%2F2022%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESection%20B%3A%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%2283.33333333333334%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3E%3CP%3E6%2F19%2F2022%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%20height%3D%2230px%22%3ETransfer%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3E%3CP%3E6%2F20%2F2022%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%20height%3D%2230px%22%3EOther%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3E%3CP%3E6%2F21%2F2022%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%20height%3D%2230px%22%3EDuplicate%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3E%3CP%3E6%2F20%2F2022%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%20height%3D%2230px%22%3ETransfer%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3E%3CP%3E6%2F19%2F2022%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%20height%3D%2230px%22%3ETranfer%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%20height%3D%2230px%22%3E%3CP%3E6%2F19%2F2022%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%20height%3D%2230px%22%3EOther%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20makes%20sense%20in%20what%20I%20am%20trying%20to%20do%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3527733%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3527814%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20creating%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3527814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1429857%22%20target%3D%22_blank%22%3E%40BettaB97%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DCOUNTIFS(%24A%2410%3A%24A%2415%2CA3%2C%24B%2410%3A%24B%2415%2C%22Transfer%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EThis%20can%20be%20done%20with%20COUNTIFS%20as%20you%20mentioned.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSUMPRODUCT((%24A%2410%3A%24A%2415%3DA3)*(%24B%2410%3A%24B%2415%3D%22Transfer%22))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EAn%20alternative%20could%20be%20SUMPRODUCT.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22countifs.JPG%22%20style%3D%22width%3A%20789px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22countifs.JPG%22%20style%3D%22width%3A%20789px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22countifs.JPG%22%20style%3D%22width%3A%20789px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F381930iBE92D7B2ADDAD8E0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22countifs.JPG%22%20alt%3D%22countifs.JPG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3527835%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20creating%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3527835%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1429857%22%20target%3D%22_blank%22%3E%40BettaB97%3C%2FA%3E%26nbsp%3BPlease%20have%20a%20look%20at%20the%20attached%20file%20and%20see%20if%20this%20does%20what%20you%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I need some help creating a formula (not that good at excel at the moment).

 

Section A:

In the transfer section I need a formula (I think a countifs one) that will see the information in section B and give a total count for cells that have the same date as Section A as well as Transfer (so it would filter out data that is on other days, even if they have transfer)

DateTransfer # 

6/19/2022

 

<---- this is where formula would be needed

6/20/2022

  

6/21/2022

  

 

Section B:

6/19/2022

Transfer

6/20/2022

Other

6/21/2022

Duplicate

6/20/2022

Transfer

6/19/2022

Tranfer

6/19/2022

Other

 

I hope this makes sense in what I am trying to do

1 Reply

@BettaB97 

=COUNTIFS($A$10:$A$15,A3,$B$10:$B$15,"Transfer")

This can be done with COUNTIFS as you mentioned.

=SUMPRODUCT(($A$10:$A$15=A3)*($B$10:$B$15="Transfer"))

An alternative could be SUMPRODUCT.

countifs.JPG