GollyWonkers
New Member
- Joined
- Jun 23, 2010
- Messages
- 4
Using Sumproduct I am attempting to check the value of two different cells that appear on multiple sheets and depending on their value add the values of a further cell across the sheets. The situation is a uniform issue for a group of people. The sheets are for individuals (in this example I'm only using two sheets). Cell G18 is the pant size, cell F18 is male or female. Cell C18 is the quanitity. I am trying to get excel to check each sheet, cell g18 for size 32 and each sheet, cell f18 for male, and then sum the total quantity from each sheet, cell c18. the formula I'm trying work with is as follows:
=SUMPRODUCT((INDIRECT("Sheet"&ROW(INDIRECT("1:2"))&"!G18")=32)*(INDIRECT("Sheet"&ROW(INDIRECT("1:2"))&"!F18")="m")*((INDIRECT("Sheet"&ROW(INDIRECT("1:2"))&"!C18"))))
Can anyone help me out? I'm getting a "#VALUE!" error message.
Thanks!
=SUMPRODUCT((INDIRECT("Sheet"&ROW(INDIRECT("1:2"))&"!G18")=32)*(INDIRECT("Sheet"&ROW(INDIRECT("1:2"))&"!F18")="m")*((INDIRECT("Sheet"&ROW(INDIRECT("1:2"))&"!C18"))))
Can anyone help me out? I'm getting a "#VALUE!" error message.
Thanks!