Sumifs

VITO

New member
Joined
Feb 18, 2017
Messages
5
Reaction score
0
Points
0
Hi,


I am looking to build a formula that does the following:

sum ifs in values column, column names does not begin with Ale and month name does not = April


Any help would be greatly appreciated, lee me know if it not clear

Thanks

Vito
 
Try
Code:
=SUMIFS(C2:C7;A2:A7;"<>"&"Ale*";B2:B7;"<>"&"April")
Please see my signature
 
Thank You!...it works perfectly


Cheers

V
 
Back
Top