# Mutli-column Formula

1. ## Mutli-column Formula

Hey guys,

Need some help writing the following formula.

Sum of cells with value "X" in column A and value "Z" in column F.

The cells must have the needed value in both columns in order to be included in the total sum.

Is this doable?  Register To Reply

2. ## Re: Mutli-column Formula

Actually, now that I think about it, it might be the sum of rows with value "X" in column A and value "Z" in column F.

Does that make more sense?  Register To Reply

3. ## Re: Mutli-column Formula

Hi btwc,

Initially I thought you may be after the excel formula sumifs

Formula:  `Please Login or Register  to view this content.`
where the values you want to sum are in range B1 to B20 in this example. However you are referring to summing a row in your second post.  Register To Reply

4. ## Re: Mutli-column Formula

Are you looking to see how many times each value shows up (counting)? Or are you looking for the sum of every value?

If you're looking for the count try this formula =SUM(COUNTIF(\$A:\$A,"X"),COUNTIF(\$F:\$F,"Z"))

If you're looking for the sum try this one =SUM(SUMIF(\$A:\$A,"X",\$A:\$A),SUMIF(\$F:\$F,"Z",\$F:\$F))  Register To Reply

5. ## Re: Mutli-column Formula

I want to know the total number of assets within that spreadsheet that have the value "X" in column A AND the value "Y" in column F. They have to meet both the "X" and "Y" criteria to be included in the sum I'm looking for.  Register To Reply

6. ## Re: Mutli-column Formula

Formula:  `Please Login or Register  to view this content.`

This formula will count how many assets have both the criteria X in column A and Z in column F.  Register To Reply

7. ## Re: Mutli-column Formula

That's exactly what I was looking for!

Thanks so much!  Register To Reply