Cannot figure out how to combine two if statements.
Worksheet 1 has detail data:
x=Name
y=Category
z=Total
In Worksheet 2 I want to summarize:
If(x=name)
and
If(y=category)
give me
z(total)
=IF(($b$5=range),IF($a4=range),range))
Cannot figure out how to combine two if statements.
Worksheet 1 has detail data:
x=Name
y=Category
z=Total
In Worksheet 2 I want to summarize:
If(x=name)
and
If(y=category)
give me
z(total)
=IF(($b$5=range),IF($a4=range),range))
Adjust ranges to suit
=SUMPRODUCT(--(Sheet1!$A$1:$A$10="Name"),--(Sheet1!$B$1:$B$10="Category")*(Sheet1!$C$1:$C$10))
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks