Counting in two columns

[MrSmith]

Hey All,

I'm not sure how to explain this so I'm going to do a little diagram.

Number | Material
----------------------
2 | Granite
1 | Marble
3 | Marble
5 | Granite

This is the data that the user enters into a spreadsheet. What I would
like to do is have a summery at the bottom of the spreadsheet with the
TOTAL number of Granite and Marble slabs entered.
I've looked at using COUNTIF for the "Material" column but I need to
take the "Number" column into account.

Any help would be greatly appreciated.
-Mark.

 

[Andy B]

Hi

Try using SUMPRODUCT.

=SUMPRODUCT((rangeB="Granite")*(rangeA))
where rangeA is your Number range and rangeB is your Material range

Andy.

 

[PJPJ]

Or SUMIF

 

[MrSmith]

Thanks all,

After trying to seach online agian I finally found some help on this.
For anyone who is intersted here's a good explanation.

http://www.beyondtechnology.com/tips101.shtml

Thanks for the help,
-Mark.