How do I compute a sum based on two columns

G

Guest

I want to compute a sum based on whether or not two columns contain certain
values. In otherwords, count the number of rows with colA = "X" and colB =
"Y".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofull formual 1
Has anyone got an efficient way to do this? 4
Pull data (sumif?) from an external workbook 1
Ranking based on two columns 10
Vlookup to Return Cell Name Not Value? 5
Making one Range out of two 2
Data in different sheets 1
Unique values in a macro 1

Top