Thread: Tricky conditional formatting and sumif function
View Single Post
 
Old 12-09-2021, 06:35 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Here you go!

Edit
About totals: When you set any filter to data table, the totals are calculated for visible rows only (i.e. they work like subtotal)!
Attached Files
File Type: xlsx Testing formulas.xlsx (20.4 KB, 8 views)
Reply With Quote