Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

XL formula help

Started by markjeffery , Mar 30 2008 07:08 AM

  • Please log in to reply

#1
markjeffery
Posted 30 March 2008 - 07:08 AM

markjeffery

    New Member

  • Member
  • Pip
  • 1 posts
Hi at present I am using =SUMIF(B4:B35,">=3.1",F4:F35) to give me a result. What I need to achieve is using 2 criteria ie >=3.1 but <10. I would appreciate some help.
Regards
Mark
  • 0

Advertisements

#2
Vino Rosso
Posted 30 March 2008 - 08:07 AM

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Not tried it but how about =SUM((B4:B35>=3)*(B4:B35<10)*F4:F35) and enter as an array (Ctrl+Shift+Enter)
  • 0
Back to Office · Next Unread Topic →




Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

  1. Geeks to Go Community
  2. → Software
  3. → Office

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP