excel nerds enter

NYSpeed Automotive NYSpeed Off Topic
1

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

2

do a sumif code

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

3

bingo

4

For that I ashame of you!

Your hacker status has been revoked.

5

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)

6

im so excited. thanks :slight_smile:

7

Dork. Excel > you. :smiley: