Forum Discussion

lc12745's avatar
lc12745
Copper Contributor
Oct 15, 2020

need formula for 2 conditions, one condition being count non blank

have spreadsheet with representative name in one column and dates in another column.  Need formula to count if rep name and date exist
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 15, 2020

lc12745 

That could be

=COUNTIFS(names,"<>",dates,"<>")
lc12745's avatar
lc12745
Copper Contributor
Oct 15, 2020

SergeiBaklan 

 

Hi, attached file as you suggested.  Need to know the number of times Katy (col. a) entered a date in "outreach cols. D & E for ID #1 in Col. B

Thanks

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 15, 2020

    lc12745 

    Sorry, what is D & E and how data in column B is related to counting if names and date?

     

    Without that formula as below, even better to use PivotTable

    • lc12745's avatar
      lc12745
      Copper Contributor
      Oct 19, 2020

      thanks so much for the help

Resources