Assist with formula to get count (unable to get it from 'Countifs' function)

Hi All,

i want to map some data (count data) from one excel sheet to another like exactly how 'sumifs' function works.

SUMIFS = sum_range, criteria_range1, creiteria1

i want = count_range, creiteria_range1, creiteria1

Please help.

Hello and welcome to the forum.

COUNTIFS and SUMIFS are a little bit different in the fact that there is no separate "count range" for COUNTIFS like there is a "sum range" for SUMIFS.

Simply put in your criteria ranges and criteria.

If you would like more specific assistance, consider uploading a small representative sample of your data along with the desired result (which you can enter manually) based on that sample.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

here is the sample file attached.

Try this:

H4 =COUNTIFS(B:B,G4,C:C,"<>")

If the Job # (column C) is being populated by a formula, and the blank cells are actually "" (not empty but showing as blank), you can use this instead:

=SUMPRODUCT((LEN(C$4:C$13)>0)*(B$4:B$13=G4))

excellent its working...

Hi Pavankumarbangaru, Please put the in Cell H4 the below formula and drag it:

=COUNTIFS($B$4:$B$13,G4,$C$4:$C$13,">""")

Great! Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.