thedeadzeds
New member
- Joined
- Oct 25, 2011
- Messages
- 37
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi Guys,
I have posted this on another forum but the formulas posted back dont seem to work. I'm hoping someone here can help
I have the following 3 IF STATEMENTS which work fine. Currently they count data based on a one date in cell E5 in the Menu tab. I want all 3 of these to calculate the data between 2 dates (the second date will be E6 on the Menu tab. Is this possible?
Many thanks
=SUMIF('Total Logged'!Q:Q,"="&Menu!E5,'Total Logged'!A:A)
=COUNTIFS('Total Logged'!Q:Q,"="&Menu!E5,'Total Logged'!I:I, "PPI Mis-sale Allegation (PPI Mis-sale Allegation)")
=SUMIFS('Total Logged'!A:A, 'Total Logged'!Q:Q,">="&Menu!E5,'Total Logged'!I:I,"PPI Mis-sale Allegation (PPI Mis-sale Allegation)")
I have posted this on another forum but the formulas posted back dont seem to work. I'm hoping someone here can help
I have the following 3 IF STATEMENTS which work fine. Currently they count data based on a one date in cell E5 in the Menu tab. I want all 3 of these to calculate the data between 2 dates (the second date will be E6 on the Menu tab. Is this possible?
Many thanks
=SUMIF('Total Logged'!Q:Q,"="&Menu!E5,'Total Logged'!A:A)
=COUNTIFS('Total Logged'!Q:Q,"="&Menu!E5,'Total Logged'!I:I, "PPI Mis-sale Allegation (PPI Mis-sale Allegation)")
=SUMIFS('Total Logged'!A:A, 'Total Logged'!Q:Q,">="&Menu!E5,'Total Logged'!I:I,"PPI Mis-sale Allegation (PPI Mis-sale Allegation)")