Counting multiple columns

[datadummy]

I need assistance writing multiple countif statements. Example countif 'Sheet1'!C1:C100,"Y" or if 'Sheet1'!D1:D100,"Y". I currently have it written as follows, =COUNTIFS('Post-Visit-Call-Raw-Data'!AE:AE,"Y",OR(IF('Post-Visit-Call-Raw-Data'!AL:AL,"Y"))) and am getting an error. Thanks in advance.

 

[Joe4]

Here is one way:

[COLOR=#333333]=COUNTIF('Post-Visit-Call-Raw-Data'!AE:AE,"Y") + COUNTIF('Post-Visit-Call-Raw-Data'!AL:AL,"Y") - COUNTIFS([/COLOR][COLOR=#333333]'Post-Visit-Call-Raw-Data'!AE:AE,"Y",[/COLOR][COLOR=#333333]'Post-Visit-Call-Raw-Data'!AL:AL,"Y")[/COLOR]

 

[marshy3300]

Easier way is to sum your answers

=SUM(COUNTIF('Post-Visit-Call-Raw-Data'!AE:AE,"Y"),COUNTIF('Post-Visit-Call-Raw-Data'!AL:AL,"Y"))

 

[datadummy]

I didn't do a very good job explain my ask, what I am trying to do is look at the columns above (AE & AN) but rather than adding them together I'm looking for a statement that will essentially say if either one has "Y" in it then count it as Y in a composite field. Hope this helps, sorry for any confusion.

 

[Joe4]

I didn't do a very good job explain my ask, what I am trying to do is look at the columns above (AE & AN) but rather than adding them together I'm looking for a statement that will essentially say if either one has "Y" in it then count it as Y in a composite field. Hope this helps, sorry for any confusion.

That is what my solution does. It counts the number of rows where a Y occurs in either column.

The logic is this:
- Add the total number of rows where "Y" occurs in column AE to the total number of rows where "Y" occurs in column AN.
- However, that could lead to "double-counting", if "Y" occurs in BOTH columns AE and AN for some rows.
- How do we account for that? Simply, subtract the number of rows where both columns "AE" and "AN" contain a "Y".

That is how my solution works.
Have you tried both of the solutions presented to see if they work?