COUNTIF For two Values

[bksparkz]

Hello Everyone.
How can I put these two formulas together?

=COUNTIF(B8:B4000,"<"&(TODAY()-180))+COUNTIF(G8:G4000,"=Y")

Basically the above formula is counting the total cells that are over 180 days long plus the total cells that include Y.
What I need is to count only cells that include a Y and are over 180 days long. If it does not include a Y and is 180 days long I do not want it counted.


Please help. Thank You.

 

[bksparkz]

Everything worked out great.
Thanks for all the help VoG

 

[VoG]

Just curious as I read this, why couldn't you have used sumifs instead of the sumproduct formula? A Sumifs would seem simpler but I may be missing a detail.

SUMIFS should work - provided that you have Excel 2007 or later. SUMPRODUCT will work in all versions.