I have attached a sample of the file I am working on. Everything is working except the autosum function in cell D9. Can anyone tell me what I am doing wrong?
I have attached a sample of the file I am working on. Everything is working except the autosum function in cell D9. Can anyone tell me what I am doing wrong?
Change D2 to =IF(C2="YES",B2,0) and copy down. I think that the issue with your current formula, it is converting all the data to text and therefore it has no numerical value.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
That did it! I am so amazed at how quickly my inquiries are answered and solved. Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks