SOLVED

What formula to use

%3CLINGO-SUB%20id%3D%22lingo-sub-1846542%22%20slang%3D%22en-US%22%3EWhat%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1846542%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20i%20am%20trying%20to%20figure%20which%20formula%20would%20work%20better%20for%20the%20following%20but%20my%20mind%20is%20stuck%20(see%20screenshot%20of%20my%20spreadsheet%20attached)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20count%20how%20many%20cells%20in%20column%20AH%20will%20contain%20the%20word%20%22Yes%22%20for%20each%20month%20(month%20will%20be%20shown%20in%20Column%20C).%20What%20formula%20do%20I%20need%20to%20use%20to%20count%20the%20%22Yes%22%20cells%20in%20column%20AH%20for%20January%20for%20example%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1846542%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1846660%22%20slang%3D%22en-US%22%3ERe%3A%20What%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1846660%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F854944%22%20target%3D%22_blank%22%3E%40Nikoss%3C%2FA%3E%26nbsp%3B%20I%20would%20think%20COUNTIFS()%20would%20work%3A%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DCOUNTIFS(AH%3AAH%2C%22Yes%22%2CC%3AC%2C%22January%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Ethat%20said%20it%20does%20depend%20on%20if%20%22January%22%20is%20text%20or%20actual%20date%20format%20and%20either%20way%20could%20be%20replaced%20using%20another%20cell.%26nbsp%3B%20For%20example%20if%20you%20had%20a%20summary%20table%20with%20Jan%2C%20Feb%2C...%20in%20a%20column%20(again%20in%20the%20same%20format%20as%20column%20C)%20then%20just%20reference%20that%20cell%20so%20when%20you%20fill%20down%20you%20get%20each%20month.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all, i am trying to figure which formula would work better for the following but my mind is stuck (see screenshot of my spreadsheet attached):

 

I am trying to count how many cells in column AH will contain the word "Yes" for each month (month will be shown in Column C). What formula do I need to use to count the "Yes" cells in column AH for January for example?

 

Thank you

 

2 Replies
best response confirmed by Nikoss (Occasional Contributor)
Solution

@Nikoss  I would think COUNTIFS() would work: 

=COUNTIFS(AH:AH,"Yes",C:C,"January")

that said it does depend on if "January" is text or actual date format and either way could be replaced using another cell.  For example if you had a summary table with Jan, Feb,... in a column (again in the same format as column C) then just reference that cell so when you fill down you get each month.

 

Thank you so much!! That works!