DB.SUM and whole cell value

  • Thread starter Thread starter IgorM
  • Start date Start date
example :

cells A1 to B4

Crop Area
wheat 5000
wheat for seed 3000
wheat for livestock 3000

cells A8 to B9
Crop Area sum
wheat 11000

formula in B9 is =DB.SUM(A1:B5;2;A8:A9)
And I want to be 5000 not 11000.


Uzytkownik "Don Guillett Excel MVP" <[email protected]> napisal w
wiadomosci grup
dyskusyjnych:1c41837e-5505-44e0-bee0-1900fc64518c@k39g2000yqb.googlegroups.com...
 
Back
Top