Title: Extra functions like excel.
Last modified: August 22, 2016

---

# Extra functions like excel.

 *  Resolved [alemitta](https://wordpress.org/support/users/alemitta/)
 * (@alemitta)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/)
 * Me again,
 * To finish my table i need a functions SUMIF but the condictions is not a number
   is YES or NO…
 * In excel is this….
 * =SUMIF(C2:C18; “SI”; D2:D18)
 * When i put this functions in tablepress error message said that it is necessary
   conditions be a number. There are any form that the conditions can be yes or 
   no?
 * Thanks!
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/#post-5503079)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * No, sorry, string comparisions are not possible 🙁
    The `IF` function in TablePress
   can only understand numbers or numeric values.
 * Regards,
    Tobias
 *  Thread Starter [alemitta](https://wordpress.org/support/users/alemitta/)
 * (@alemitta)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/#post-5503086)
 * Me again,
 * And…Is it possible that when put NO in a field this file became in other color?
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/#post-5503089)
 * Hi,
 * not directly, and not with formulas. You would have to use some custom PHP code
   for this that, for example, hooks into the `tablepress_cell_css` plugin filter
   hook, and adds an extra CSS class to the cell, if the cell content is “NO”. With
   that CSS class, you can then set an extra background color in the cell.
 * Regards,
    Tobias
 *  Thread Starter [alemitta](https://wordpress.org/support/users/alemitta/)
 * (@alemitta)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/#post-5503099)
 * Hi tobias,
 * Me again.
 * I not very expert in php, but i thinks would be something like this…
 * <?
    if ($row[“Alquilado”]=NO) echo ‘<tr style=”background-color:#ff0000″>’; ?
   >
 * But I cant find where put it.
 * Thanks for your help.
 *  Thread Starter [alemitta](https://wordpress.org/support/users/alemitta/)
 * (@alemitta)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/#post-5503101)
 * <?
    if ($column[“Alquilado”]=NO) echo ‘<tr style=”background-color:#ff0000″>’;?
   >
 * Sorry
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/#post-5503124)
 * Hi,
 * no, that’s a little bit too easy. You would have to write a small custom WordPress
   plugin that uses `add_filter()` to hook into `tablepress_cell_css_class`, which
   gets passed several parameters, see [https://github.com/TobiasBg/TablePress/blob/1.5.1/classes/class-render.php#L648](https://github.com/TobiasBg/TablePress/blob/1.5.1/classes/class-render.php#L648)
   
   That information can then be used for the check. You could maybe try using the
   other available TablePress Extensions as the starting point for your custom Extension.
 * Regards,
    Tobias
 *  Thread Starter [alemitta](https://wordpress.org/support/users/alemitta/)
 * (@alemitta)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/#post-5503299)
 * I tried to do it but it is so difficult for me.
 * Could you help me?
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/#post-5503300)
 * Hi,
 * I would love to, but unfortunately I just don’t have time to develop this Extension
   within the free support that I can offer, sorry 🙁
 * Regards,
    Tobias

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Extra functions like excel.’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 8 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [11 years, 6 months ago](https://wordpress.org/support/topic/extra-functions-like-excel/#post-5503300)
 * Status: resolved