Automatically include added rows in complex formula?

[HelpMeWithExcelPlease]

Hi all,

Hoping someone can answer this question for me. I have a dashboard on one tab and a raw data sheet on the other. The dashboard has COUNTIFS() formulas pulling data from the raw data sheet, but my issue arises from when I add rows to raw data sheet and the COUNTIFS() do not include these new rows. How can I rewrite my COUNTIFS() formula to automatically recalculate whenever I add in new rows to the raw data sheet?

For Example:
If I have data in rows 2-5 and my formula is as follows:
=COUNTIFS($A$2:$A$5,"Yes",$B$2:$B$5,"Blue")+COUNTIFS($A$2:$A$5,"Yes",$C$2:$C$5,"Green")+COUNTIFS($A$2:$A$5,"Yes",$D$2:$D$5,"Yellow")

When I add in data to row 6 how will I make it so that my COUNTIFS() function will include that data in the count as well?

 

[Beyond_avarice]

Your Criteria range has been restricted to A2:A5, B2:B5, C2:C5 and D2:D5. If you want to include rows below five, stipulate the entire columns:

=COUNTIFS(A:A,"Yes",B:B,"Blue")+COUNTIFS(A:A,"Yes",C:C,"Green")+COUNTIFS(A:A,"Yes",D:D,"Yellow")

 

[HelpMeWithExcelPlease]

Hey Beyond_avarice,

Thanks for the idea, I appreciate it! My only issue is that I have to start the range at row 2, so I can't have it do a count for the entire column. Any ideas on how to rewrite it so that it only includes added rows beneath the last row?

Thanks!

 

[Beyond_avarice]

If Row 1 will never contain the "criteria1"(arg2) or "criteria2"(arg4). Then it wont matter if you include that row.