Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jackie
 
Posts: n/a
Default sumif statement

I am begging for your help again ...
I would like to add another if statement to the following statement but keep
getting errors so obviously I am missing something:

=sumif(e2:e10,"1",g2:g10)and if(h2:h10,"1")

Basically what I am trying to do is sum a column g2:g10 only if both of the
other columns are 1. I will also be changing it to e is 1 & h is 2 ....
any ideas? ....
--
Jackie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif statement JR573PUTT Excel Discussion (Misc queries) 5 February 17th 06 04:01 PM
Nested SumIf statement jlhart76 Excel Worksheet Functions 7 January 18th 06 04:27 PM
my sumif statement brings back mutiple answers, how do I fix it? graham Excel Worksheet Functions 2 November 15th 05 08:14 PM
Do I need a sumif or sum of a vlookup formula? PeterB Excel Worksheet Functions 0 June 1st 05 12:23 PM
sumif statement Ted Metro Excel Worksheet Functions 1 January 7th 05 04:18 PM


All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"