View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How can I sum a range using two parameters (eg location & date)

Depends on your data set-up. For better answers, elaborate here with some
samples, the expected results, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gory" wrote in message
...
I am trying to sum a range of cells based on the location (listed
vertically)
the item was used and the date (listed Horizontally) the item was used.