Apr 16 2020 06:09 AM
I would like to be able to keep track of our cisco blades cores and what we are using them for. So I want to be able to put in a blade name, the number of cores, and what it is used for. I would then like for a formula to be able to look for the X in column C-F and get the number from column B and add that into the total for the cells in J. Can this be done?
Apr 16 2020 06:38 AM - edited Apr 16 2020 06:43 AM
Apr 16 2020 06:42 AM
Apr 16 2020 07:08 AM
Solution@kristophersmith Easier would be to put your summary on a row. If you have the latest Excel, you can put the the way you had them in your screenshot with the TRANSPOSE function.
Please see attached.
Apr 16 2020 07:29 AM
@Riny_van_Eekelen How do you get it to total up at the bottom using the number from B based on if there is an X in C or any column.. I really know nothing about formulas and tables within Excel.. What would the function be called? Is that the sum based on criteria?
Apr 16 2020 07:41 AM
The SUMIF function looks for the "x" in the cells above and then sums the values from column B for those rows that have the "x" in either C, D, E or F.
Apr 16 2020 07:08 AM
Solution@kristophersmith Easier would be to put your summary on a row. If you have the latest Excel, you can put the the way you had them in your screenshot with the TRANSPOSE function.
Please see attached.