Hi and hopefully im posting this into rigft area . been away from spreadsheets for a few years and working on various personal items to get myself back into the right though process
currently im doing a personal work data sheet reading call volumes for myself on a dialy basis, i have it set on seperate rows. but ideally id like data on seperate rows but totals in one cell
figured i could possible use a drop down menu and then if function to read the relevant values,,
so what i have is
if A1 is set to display Mon, then reads set values stated
=IF(A4="mon",(K4+L4+M4))
one formula works fine ..however i want this set so that it will read different parameters if a different day is chosen. i can get it in seperate cells but that defeats the object. and cant seem to work out the multriple formula for it to read all in same cell
i tried things like this
=IF(A4="mon",(K4+L4+M4))*or=IF(A4="Tue",(K5+L5+M5))
but didnt work so decided to ask someone smarter . any help would be greatly appreciated
Bookmarks