# excel nerds enter

**URL:** <https://forums.speedlife.net/t/excel-nerds-enter/48347>\
**Category:** NYSpeed Off Topic\
**Created:** [May 13, 2008, 7:22am UTC](https://forums.speedlife.net/t/excel-nerds-enter/48347 "2008-05-13T07:22:54Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Locutus](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/locutus/32/7574_2.png) [@Locutus](https://forums.speedlife.net/u/Locutus)\
**Post date:** [May 13, 2008, 7:22am UTC](https://forums.speedlife.net/t/excel-nerds-enter/48347/1 "2008-05-13T07:22:54Z")

</div>

i want to be able to SUM multiple values in multiple worksheets if it matches a key

for example

i have multiple rows that are catorigized by a priority level (1-5)  
on a main page i want to sum up all of the priority level 1’s…

sudo code

if hardware! (worksheet)  
C7 (cell)  
=1  
Then  
SUM  
E7

but i need it to check the entire worksheet.

help. 10 min. go

---

<div class="post-metadata">

**Author:** ![POOPRA](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/poopra/32/7188_2.png) [@POOPRA](https://forums.speedlife.net/u/POOPRA)\
**Post date:** [May 13, 2008, 7:55am UTC](https://forums.speedlife.net/t/excel-nerds-enter/48347/2 "2008-05-13T07:55:14Z")

</div>

do a sumif code

=SUMIF(cells with the 1-5,1,cells to sum)

---

<div class="post-metadata">

**Author:** ![Griff](https://avatars.discourse-cdn.com/v4/letter/g/f19dbf/32.png) [@Griff](https://forums.speedlife.net/u/Griff)\
**Post date:** [May 13, 2008, 8:09am UTC](https://forums.speedlife.net/t/excel-nerds-enter/48347/3 "2008-05-13T08:09:39Z")

</div>

bingo

---

<div class="post-metadata">

**Author:** ![Ovrwrkd](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ovrwrkd/32/7586_2.png) [@Ovrwrkd](https://forums.speedlife.net/u/Ovrwrkd)\
**Post date:** [May 13, 2008, 9:28am UTC](https://forums.speedlife.net/t/excel-nerds-enter/48347/4 "2008-05-13T09:28:41Z")

</div>

For that I ashame of you!

Your hacker status has been revoked.

---

<div class="post-metadata">

**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\
**Post date:** [May 13, 2008, 9:35am UTC](https://forums.speedlife.net/t/excel-nerds-enter/48347/5 "2008-05-13T09:35:32Z")

</div>

I don’t know how you can do it across multiple files but on multiple “sheets” it would be something like

=SUM(E8:L8,Sheet2!D4:M4,Sheet3!E6:N6)

---

<div class="post-metadata">

**Author:** ![Locutus](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/locutus/32/7574_2.png) [@Locutus](https://forums.speedlife.net/u/Locutus)\
**Post date:** [May 13, 2008, 10:42am UTC](https://forums.speedlife.net/t/excel-nerds-enter/48347/6 "2008-05-13T10:42:20Z")

</div>

im so excited. thanks 🙂

---

<div class="post-metadata">

**Author:** ![Tevenor](https://avatars.discourse-cdn.com/v4/letter/t/8baadc/32.png) [@Tevenor](https://forums.speedlife.net/u/Tevenor)\
**Post date:** [May 13, 2008, 12:00pm UTC](https://forums.speedlife.net/t/excel-nerds-enter/48347/7 "2008-05-13T12:00:20Z")

</div>

Dork. Excel \> you. 😃