Hi,
I want to assign the value of cell AB6 into my COUNTIFs formula as show in the image. When I input it however, it doesn't seem to work. Does anyone have a workaround?
EDIT: Just to clarify, I want my formula to count up any of the values in the table in W:W which are under the value in AB6.
I want to assign the value of cell AB6 into my COUNTIFs formula as show in the image. When I input it however, it doesn't seem to work. Does anyone have a workaround?
EDIT: Just to clarify, I want my formula to count up any of the values in the table in W:W which are under the value in AB6.
Attachments
Last edited by a moderator: