Forum Discussion

little2fern's avatar
little2fern
Brass Contributor
Mar 23, 2020
Solved

Formula to pull out data according to the dates and topic

Hello,   I want a formula to put into F2, F3, J2, J3. The formula which could pull out data from my other spreadsheet seen below according to the dates I put into B2 and B3. Note that the cou...
  • Riny_van_Eekelen's avatar
    Mar 23, 2020

    little2fern 

    Use SUMPRODUCT in the following way. For "Answered" in F2;

    =SUMPRODUCT('2020 All Protollcall data'!C2:C500*('2020 All Protollcall data'!A2:A500<=$B$3)*('2020 All Protollcall data'!A2:A500>=$B$2))

     ......... where you need to adjust the ranges C2:C500 and A2:A500 to ones that match the data sheet. For "Unanswered" you need to replace the first range by D2:D500, and similarly for the two other categories (col E and F in your data sheet) you want to count.

     

Resources