Let me explain this with an example - If column A, C, E, G are for denoting expenses [just numbers] and column B, D, F, H denote different methods used in expenses like cash, card, paytm etc selected via dropdown data validation; then I want to add the cells A, C, E and G and get a total cash expenditure of the day in column I. Can anybody help me solve this query? Thanks in advance for your time and effort.
I have edited this post and uploaded an excel file. In the attached file how can I calculate the total cash expenditure on 01/12/2020. As you can see that some of the payments on that day have been made through card the others through cash. So i want that In K3 I can get a total of all the cells which are cash payments. Then I will replicate this formula for the rest of the cells in that column by dragging the formula. Sorry for not being able to explain myself in the first time.
Bookmarks