Using countifs

Topic

New Reply

I would like to use the following formula and replace the dates with a cell reference.
=COUNTIFS(Pith_Date,”>=1/1/1995″,Pith_Date,”25″)

What I’d like is something like this:
=COUNTIFS(Pith_Date,>=A3,Pith_Date,25″)

Possible? I couldn’t get it to work.
It would save me a lot of cell editing if it can be made to work.

The worksheet is attached

as always, THANKS!

Reply | Quote

Replies

You have to put the non cell in quotes and concatenate:
=COUNTIFS(Pith_Date,”>=”&A3,Pith_Date,”25″)

If you put 25 in C2 you can use:
=COUNTIFS(Pith_Date,”>=”&A3,Pith_Date,””&$C$2)

You can display the text yoyu have in C2 using the custom number format:
“Days > “0” cfs”

Then if you change C2 all the cells will be updated with the new number.

Steve

Reply | Quote

Thanks!

BTW, your revision turned up an error in my typing in the dates, so DOUBLE THANKS!

Reply | Quote