You want:
=IF($M1222=U$11,$H1222,0)
so the row adjusts as you copy down, but column M remains the same as you copy across.
You want:
=IF($M1222=U$11,$H1222,0)
so the row adjusts as you copy down, but column M remains the same as you copy across.
Be as you wish to seem
Posting Permissions
Reply With Quote