SUMIF does exactly what you want, and this is a 2D reference. 3D references
apply data to the same positions across multiple pages.

=SUMIF($B$1000,"billable",$A$1000)

--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"JeffPlax" wrote:

I have a series of spreadsheets, and I need to sum the hours only if they are
billable

column A contains hours, and column B indicates weather hours in column A
are billable or not (Yes or No). Does SUMIF work using 3D-references?