Forum Discussion

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...

excel

Formulas and Functions

Riny_van_Eekelen
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.

Riny_van_Eekelen

Platinum Contributor

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.

little2fern
Brass Contributor
Mar 23, 2020
Riny_van_Eekelen
Thank you so much again. You are very kind ><
SergeiBaklan
Diamond Contributor
Mar 23, 2020
Riny_van_Eekelen , sorry, didn't see you already answered
- Riny_van_Eekelen
  Platinum Contributor
  Mar 23, 2020
  SergeiBaklan No problem! Happens to me frequently that I'm just after someone else. Anyhow, your solution is different, so it just adds another option.