Counting two criteria - IF figure= and if date is older than 30 days.

[Rhys Lewis]

Hi all,

I am trying to create a formula to count if cells D6:100 = 0 and if the date in cells B6:100 are older than 30 days, but I cant seem to figure this out.

I am using the following formula but this is just giving me "VALUE".

=SUM(IF(D6:D100="0",IF(B6:B100=">"&TODAY()-30,1)))

I have also tried -

=COUNTIF(D6:D100="0",B6:B100=">"&TODAY()-30,1)))

Could anyone assist please!

Many thanks!

 

[steve the fish]

See if this works:

=COUNTIFS(D6:D1000,0,B6:B1000,"<"&TODAY()-30)

 

[Rhys Lewis]

That worked perfectly, thank you!