Cells display a total or text
Solved/Closed
Related:
- Cells display a total or text
- Total copy - Download - File management
- Total war warhammer 3 free download - Download - Strategy
- Total video converter - Download - Video converters
- Total video player - Download - Video playback
- Total uninstall - Download - Cleaning and optimization
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
10 Nov 2011 à 10:36
10 Nov 2011 à 10:36
Hi Michael,
Try this formula in T53:
=IF(T(U43)="",IF(T(U45)="",IF(T(U47)="",IF(T(U49)="",IF(T(U51)="",IF(T(Q53)="",SUM(U43,U45,U47,U49,U51,Q53),Q53),U51),U49),U47),U45),U43)
Best regards,
Trowa
Try this formula in T53:
=IF(T(U43)="",IF(T(U45)="",IF(T(U47)="",IF(T(U49)="",IF(T(U51)="",IF(T(Q53)="",SUM(U43,U45,U47,U49,U51,Q53),Q53),U51),U49),U47),U45),U43)
Best regards,
Trowa
11 Nov 2011 à 18:05