Main Page | Report this Page
Computers Forum Index  »  Computer Applications - Spreadsheets  »  SumIf formula with multiple criteria...
Page 1 of 1    

SumIf formula with multiple criteria...
Author Message
Ambassador...
Posted: Thu Jul 09, 2009 11:56 pm
Guest
Given range named "type" and "qty", i am trying to write a formula that will
sum the "qty" of multiple "type"s together. I've tried
=sum(if((type="apples")+(type="oranges"),qty,0) and
=sumif(type,(or("apples"),("oranges")),qty)
neither work....can someone help me
Back to top  
 
    Display posts from previous:  
Page 1 of 1    
All times are GMT
The time now is Mon Nov 30, 2009 8:45 am
Computers Forum Index
 

Powered by phpBB & ML | Privacy Policy / Disclaimer



Contact Us