View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Sum with two conditions

"Khally" wrote:
I did not understand which branch. please advise


Here's what I posted over there ..
-----
"Khally" wrote:
Both the options are not working for me.


Then it could be a data consistency issue between what you actually have in
the source sheet: Data (in the "Stock#" col and/or in the "Month" col), and
what you have set up as the col / row headers in the other "summary" sheet.
If the data isn't consistent, then the SP formula as earlier suggested won't
work properly.

Anyway, here's a quick working sample for the earlier SP suggestion:
http://cjoint.com/?iomo3rW0Zs
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---