Forum Discussion
Formula to pull out data according to the dates and topic
- Mar 23, 2020
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.
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.
- little2fernMar 23, 2020Brass Contributor
Thank you so much again. You are very kind ><
- SergeiBaklanMar 23, 2020Diamond Contributor
Riny_van_Eekelen , sorry, didn't see you already answered
- Riny_van_EekelenMar 23, 2020Platinum Contributor
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.