# Sum if, countifs and count if issues

##### New member
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

=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)")

#### NBVC

##### Super Moderator
Staff member
Can you post the link to the other forum so that we may see what was suggested and/or what did not work?

My guess... for example the first SUMIF will now be:

and similarly for the other 2 formulas, you would adjust and replace the current Q:Q conditions to include the red part above.

##### New member
Hi, Thanks for that but unfortunately that is bringing up an error message. I have uploaded the file so hopefully this makes it easier. I;m trying to get the formulas in cells E10, E12 AND E14 to calculated based on the dates in cells E5 AND E6. Many thanks in advance

#### Attachments

54.3 KB · Views: 10

#### NBVC

##### Super Moderator
Staff member
I don't get any errors....

In E10:

=SUMIFS('Total Logged'!A:A,'Total Logged'!Q:Q,">="&Summary!E5,'Total Logged'!Q:Q,"<="&Summary!E6)

in E12:

=SUMIFS('Total Logged'!A:A,'Total Logged'!Q:Q,">="&Summary!E5,'Total Logged'!Q:Q,"<="&Summary!E6,'Total Logged'!I:I,"PPI Mis-sale Allegation (PPI Mis-sale Allegation)")

in E14:

=SUMIFS('Total Logged'!A:A,'Total Logged'!Q:Q,">="&Summary!E5,'Total Logged'!Q:Q,"<="&Summary!E6,'Total Logged'!I:I,"<>PPI Mis-sale Allegation (PPI Mis-sale Allegation)")