cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Sum columns when cell contains text

Lhud2300
Copper Contributor

‎Oct 07 2020 03:04 AM

‎Oct 07 2020 03:04 AM

Sum columns when cell contains text

Hi,

 

I am trying to sum F3+G3+H3 if B3 contains text, otherwise leave the cell blank and im struggling with the formula.

 

Thanks

Labels:
490 Views
0 Likes
1 Reply
Reply
1 Reply
Hans Vogelaar

‎Oct 07 2020 03:13 AM

‎Oct 07 2020 03:13 AM

Re: Sum columns when cell contains text

@Lhud2300 

=IF(ISTEXT(B3),SUM(F3:H3),"")

0 Likes
Reply