Forum Discussion

ltsimmons's avatar
ltsimmons
Copper Contributor
Mar 07, 2022

Countif

I need help with a formula:  In cell with ?...If column "A" matches "A2" and matches "C1", count column "C".   The return should be 4   0 1 11/1/2021   ?             11/1/2021...
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 07, 2022

ltsimmons 

=SUMPRODUCT((MONTH(A5:A13)=C1)*(A5:A13=A2)*C5:C13)

Maybe with this formula. 

  • ltsimmons's avatar
    ltsimmons
    Copper Contributor
    Mar 07, 2022

    OliverScheurich  Thank you much...I'm still not sure why this doesn't work...could it be my column "C" is formatted for "Hour"?

     

     

     

     

    • OliverScheurich's avatar
      OliverScheurich
      Gold Contributor
      Mar 07, 2022

      ltsimmons 

      Does it work when you open the attached file?

       

      I assume you don't work with the german version of Excel and that's why SUMMENPRODUKT returns the #Name error in your sheet.

       

      If you work with the english version of Excel you can enter formula:

      =SUMPRODUCT((MONTH(A5:A13=C1)*(A5:A13=A2)*C5:C13))

       

      • ltsimmons's avatar
        ltsimmons
        Copper Contributor
        Mar 07, 2022
        I copied and paste it and I keep getting zero as a result...thank you anyways, I appreciate it. Maybe something is wrong with my file.