ExcelBanter - Multiple CountIf Criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple CountIf Criteria (https://www.excelbanter.com/excel-worksheet-functions/50512-multiple-countif-criteria.html)

JerryS

Multiple CountIf Criteria

I'm trying to set up a formula that provides a total if two values equal
desired values. For example, if A1=1 and B1=100, I want a total for column B
for cells that have a value of 1 in A. Any suggestions?
--
JerryS

Biff

Hi!

Try this:

=SUMIF(A1:A50,1,B1:B50)

Biff

"JerryS" wrote in message
...
I'm trying to set up a formula that provides a total if two values equal
desired values. For example, if A1=1 and B1=100, I want a total for column
B
for cells that have a value of 1 in A. Any suggestions?
--
JerryS

All times are GMT +1. The time now is 10:11 PM.