Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADDING AN AND

Status
Not open for further replies.
ptweb

ptweb

Programmer
Jul 1, 2005
37
0
0
GB
Hi

=SUMIF(G2:G36,0,E2:E36) I would like to add a AND condition to this sum so that H2:H36 also equal 0... bit confused
 
Sort by date Sort by votes
Please post in the MS Office forum and provide more information

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
140
feipezi
feipezi
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
220
SkipVought
S
JAB_123
  • Locked
  • Question
I want to use an excel file for inp
Replies
3
Views
92
dhookom
dhookom
jtm2020hyo
  • Locked
  • Question
VBA script to split 0D, 1D, and 2D arrays 1
Replies
10
Views
133
jtm2020hyo
jtm2020hyo
feipezi
  • Locked
  • Question
How to detect dups and/or sum by group?
Replies
1
Views
60
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top