Thread: sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Sulasno[_2_] Sulasno[_2_] is offline
external usenet poster
 
Posts: 13
Default sumif

still trying to find a way to use 2 criteria within 2 ranges to add 1 range
of data;

range1 range2 criteria1 criteria2 data

=sumif(range1,criteria1,data)+sumif(range2,criteri a2,data) will give twice
the amount