excel argument

[Ken]

I am having difficulty writing a formula as follows: I have 5 cells
for recording throughput eg. A3 through E3 each represents a different
process center. In cells A6 through E6 is the expected target for
each process center. In another "summary" sheet, say in A1 and A2, I
need to put the total throughput and total target, which is simple
enough to do with the throughput but the targets will change depending
on whether the machine center for that day is scheduled to operate. I
need to know how to input a formula that will take into consideration
something like this.
DATA ENTRY SHEET
A B C D E
1
2
3 Vol 20 0 10 "" 50
4 Target 15 20 12 "" 50

The cell in the "summary sheet" appears to have to have a lot of
"if's" EG IF A5=20 AND B5=0 AND C5=10 AND D5=BLANK AND E5=50 THEN A2
ON THE SUMMARY SHEET WOULD = DATA A6 + DATA B6 + DATA C6 + DATA E6 AND
WOULD IGNOR DATA D6. Any of the vol cells could either be blank or
have a number in them,which would generate a target. I would
appreciate any help anyone can give me. Please email your response to
(e-mail address removed) Thanks.

 

[Frank Kabel]

Hi
try something like
=SUMIF(A5:E5,">0",A6:E6)