Hi everyone!
I'm trying to create a formula that will count +1 if two different criteria is met. This is returning as "0" in 2 different scenarios:
--SCENARIO 1: COUNTIFS--
In detail, what I need the formula to do is this:
- This property belong to "Rita" (from Row6 in "Propiedades" tab)
- It is considered "Terreno" (from Row9 in "Propiedades" Tab)
- If both conditions are met, count +1
The formula that I'm using is =COUNTIFS(Propriedades!6:6,"Rita",Propriedades!9:9,"Terreno") and you can find it in the "Overview" tab on D4.
---------------------------------------------------------------------------------------------
--SCENARIO 2: SUMIF--
Similarly, I would like to sum the total price of all properties that belong to Rita:
- Property taken from Row6 in "Propiedades" tab
- Total price are the 4 big green numbers found in Row15 in "Propriedades" tab
The formula that I'm using is =sumif(Propriedades!6:6,"Rita",Propriedades!15:15), and you can find it in the "Overview" tab on G4
I'd love to understand what the right formulas should be, and what is causing the error so I can learn what to do (or not do) next time.
I'm primarily working on this on a Google Sheet: however, I posted in the formulas & functions section as the formulas in this case for COUNTIFS and SUMIF are identical between Excel or Sheets, so I attached a .XLSX file; I'm not sure if the nice formatting I worked hard on creating will stick on the XLSX version, but that should be irrelevant for this exercise.
Thanks for your time!
Bookmarks