Good Day
Please could someone assist with attached file.
I have a formula in column Z, Though I would like it to work with Data Validation as it would be easier than typing out the specific values.
Kind Regards
Kesh
Good Day
Please could someone assist with attached file.
I have a formula in column Z, Though I would like it to work with Data Validation as it would be easier than typing out the specific values.
Kind Regards
Kesh
In Z4
=SUMPRODUCT(($D$2:$Y$2)*($D4:$Y4="Yes"))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks