Friday, July 19, 2013

yogi_Formula For Conditional MultiColumn SUM That Works In Google Spreadsheet As Well As In Excel

                                          Google Spreadsheet   Post  #1294
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 19, 2013
user post by Arvydas Ruibys question by Thao Duong K.Y (http://productforums.google.com/forum/?zx=vofu5btd8s4i#!category-topic/docs/spreadsheets/Xiw4H_eqvuU)

I have a problem with SUMIF() because the sum_range includes numbers as well as "//". Anybody can help?
---
Hi Kishan,

Thank you for your help. Could you please give me an example in this file: https://docs.google.com/spreadsheet/ccc?key=0At9wLhzVmNbEdFhWYVl5TE9veUJBRTd6RllxWXMwamc&usp=sharing ?

In the file, I'm trying to sum the range C4:E15 which contain "General" text.

I'm looking forward to your feedback.

Thanks,
Thao

---
Thanks, Kishan. The formula works well on Google Spreadsheet, but it's a pity, it doesn't work on MS Excel. It seems the Filter() doesn't exist in MS Excel. Could you please adapt it soon?

Thanks,
Thao

-------------------------------------------------------------------------------------------------------------------------------------------------------------