CountIf Depending on horizontal and vertical criteria

**Jamidd1** · 02-17-2018, 03:39 PM

Hi Excel Forum,

I am trying to count Y's in a range depending if there is "*L2*" in a column range & "M" in a row range.

I have attached a workbook with an example of my desired result as this seems to help a lot more then me trying to explain my desired outcome i will show you haha.

Thanks in advance

Jamidd

**Root_** · 02-17-2018, 04:22 PM

Try

=SUMPRODUCT(--(I2:AN31="Y"),(E2:E31="M")*ISNUMBER(FIND("L2",I1:AN1)))

Note: FIND() is case-sensitive. If you need to look for "l2" as well, replace FIND with SEARCH.

**Jamidd1** · 02-18-2018, 05:24 PM

Thank you very much Root! This seems to be working.

Ill set the thread to solved, if i have any problems will hit you back.

Cheers again.

CountIf Depending on horizontal and vertical criteria

LinkBack

Thread Tools

Rate This Thread

Display

CountIf Depending on horizontal and vertical criteria

Re: CountIf Depending on horizontal and vertical criteria

Re: CountIf Depending on horizontal and vertical criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Transpose vertical to horizontal data based on countif?

SUMIFS with vertical criteria and horizontal criteria (horiz. crit. is a date range check)

sum array depending on vertical & horizontal references

[SOLVED] Lookup with vertical and horizontal criteria

Countif function - horizontal and vertical textlookup

Auto populate a cell depending on last entry and vertical position in a horizontal range

[SOLVED] countif, fill horizontal, lookup vertical

Bookmarks

Bookmarks

Posting Permissions