Dragged down formua

seanyx · #1 07-23-2021, 02:44 AM

If a cell in column C-N has a text "A,K,D,P" then the value is 0.5, if all 12 cells have specific text the value in column O must be 6. I don't understand the formula inserted in column O and everytime I copy the formula it doesn't apply the needed value. Please view my file and explain.

Purfleet · #2 07-23-2021, 11:36 AM

you have to track it back, O is half if AE, AE is a sum of w,y,ac,aa

it appears to be count half days

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2007:- Opening up a dragged in .msg to a folder brings up an error message	Snooker	Outlook	0	03-21-2021 05:18 PM
How I convert formua into VBA code I need help	Moot70	Excel Programming	1	10-27-2019 06:15 AM
Is a folder or email being dragged?	Smallweed	Outlook	0	01-06-2015 08:50 AM