I can determine how many cells in Column D with the year 2015 there are. And I can count the number of cells in Column L that are 15 or larger. I want to merge these two formulas, but I'm not sure how to do it.

The formula I use to count the years is:

=SUMPRODUCT(--(TEXT('Sheet1'!D:D,"YYYY")="2015"))

The formula for counting 15 or greater is:

=COUNTIF('Sheet1'!L:L,">=15")

Can someone please provide a way I can combine these two formulas so I can count how many instances there was 15 or greater for the year 2015?

Oct 2, 2022 in Others 109 views

## 1 answer to this question.

COUNTIFS() with an S allows the ability of multiple criteria and you can bracket the dates:

```=COUNTIFS('Sheet1'!L:L,">=15",'Sheet1'!D:D, ">=" & DATE(2015,1,1),'Sheet1'!D:D, "<=" & DATE(2015,12,31))
``` If your dates are actually text strings that look like dates you can do the:

`=COUNTIFS('Sheet1'!L:L,">=15",'Sheet1'!D:D,"*2015*")`
• 53,160 points

## datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

## Format an Excel column (or cell) as Text in C#?

When I copy values from a data ...READ MORE

## Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

## How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

## Excel Formula Query on Summing Annual Leave Days and Half Days

Try Something like =SUM(COUNTIF(\$A\$1:\$A\$8,"A"),COUNTIF(\$A\$1:\$A\$8,"HA")/2) - total count ...READ MORE

## How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE

## Want to compare two columns in excel

Hello To compare two columns in excel ...READ MORE