Forum Discussion
Stephen Coff
Aug 01, 2017Copper Contributor
Any Help Is Appreciated
Guys, Any help is appreciated, I don't deal with excel much, only on a very basic level. To most on here I'm sure this is very simple though this simpleton is lost. On my "Condenser Selection" sh...
Stephen Coff
Aug 02, 2017Copper Contributor
Yury,
Likely stretching the appreciation some.
Please find attached:
Is there a way to calculate the total "# of Cond" per "Condenser Model" and display in the top cells filled red?
Yury Tokarev
Aug 02, 2017Steel Contributor
Hi Stephen,
you can use SUMIFS function. An example in cell L5 would be '=SUMIFS($C$9:$C$76,$G$9:$G$76,J5)'. Please note that I have removed call merge from the 'Design Criteria' and 'Selection Data' headers and replaced it with 'Centre Accross Selection' (Format Cells ->Alignment->Horizontal). This is better, because it allows to select columns as desired (e.g. '# of Cond" and 'Condenser Model') and avoids confusion in formulas when selecting ranges.
Please see the updated file attached.
If you find my answer userful and like it, I would appreciate you clicking the 'Like' button :)
Thank you
Yury
- Stephen CoffAug 02, 2017Copper Contributor
Yury,
Perfect ! Thank you.
I bet it took the best part of a few mins, i had played with it for a couple of hours and gave up, lol